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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.