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.
I want to thank everyone in advance for their assistance in helping with this issue.