• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Formula to Sort Warehouse Bin Locations

sfergus9

New Member
Hello, I need some help with a complex sorting problem in Excel. It has to do with sorting warehouse bin locations for physical inventory and cycle counting to aid count teams in a process structure to not miss any inventory. I've attached a worksheet with two tabs - one shows how a warehouse is typically laid out - nomenclatures, etc. and the other tab is a sample data set and what I'd like to see as a result.

I want to thank everyone in advance for their assistance in helping with this issue.
 

Attachments

  • Chandoo Bin Locations.xlsx
    442.4 KB · Views: 39
In G5: =C5&IF(ISEVEN(D5),D5+100,D5+200)&E5
Copy down
Include Column G in the Filter
Sort on Column G
Print a list now without Column G

upload_2018-10-5_23-45-19.png
 
Back
Top