Define pick sequence order against locations

Hi,
Seeking help with a formula to help determine the unique pick sequence order to guide picker to next location


Sample provided attached with expected order and result in 'sample pick sequence tab'


Thank you!

Formula in cell A2 of the sample pick sequence sheet of your file:
=SORT(FILTER('location file'!$A:$G,ISNUMBER('location file'!G:G)),7)
If it shows #SPILL! clear the cells below and to the right.

See attached drawings with zig zag pathway being the rule to determine the pick sequence number, the formula is required in col g pick sequence in the first tab location file

Numbers at the top of your diagram: Rows or Shelves?
Really, explain clearly what you want.

Also:
cross posted without links:
Define pick sequence order against locations - Excel Formulas - OzGrid Free Excel/VBA Help Forum
https://www.ozgrid.com/forum/index.php?thread/1230773-define-pick-sequence-order-against-locations/
Define pick sequence to location | Chandoo.org Excel Forums - Become Awesome in Excel
https://chandoo.org/forum/threads/define-pick-sequence-to-location.47258/
Define pick sequence order against locations
https://www.excelforum.com/excel-fo...ne-pick-sequence-order-against-locations.html

imohammed999, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184