Results 1 to 4 of 4

Thread: Define pick sequence order against locations

  1. #1
    Neophyte imohammed999's Avatar
    Join Date
    Dec 2021
    Posts
    2
    Articles
    0
    Excel Version
    365

    Define pick sequence order against locations



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,062
    Articles
    0
    Excel Version
    365
    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.

  3. #3
    Neophyte imohammed999's Avatar
    Join Date
    Dec 2021
    Posts
    2
    Articles
    0
    Excel Version
    365
    Click image for larger version. 

Name:	Screenshot 2021-12-04 064546.png 
Views:	8 
Size:	33.7 KB 
ID:	10722

    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

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,062
    Articles
    0
    Excel Version
    365
    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.p...nst-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-for...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
    Last edited by p45cal; 2021-12-04 at 12:24 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •