-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
warehouse
-
J
match data by keyword
hi all :) i need a formula to match data in 2 columns that is not necessarily exact - therefore i'm thinking if i can identify field that have a common field i can see if the data within an index is a match. for example in the if i had a formula for the first cell (software warehouse) it would...- jcaston85
- Thread
- data exact field match warehouse
- Replies: 1
- Forum: Excel Questions
-
B
FInd most common variation of product combination of with order type and complete order details
I am trying to use a sample size worth of orders to create a relationship in regards to parent-child relationships and most common occurrences of each relationship. I have tried to use several different variations of if statements along with MODE.MULT, VLOOK, TRANSPOSE, SUMPRODUCT to determine...- bbell2219
- Thread
- common values multi criteria match ordered list slotting warehouse
- Replies: 5
- Forum: Excel Questions
-
S
Number Sequence for Warehouse layout
Help I am looking to do a warehouse layout, and want to assign a pallet location to products. However some products I can put 4 items into one location (0.25) and others only 2 (0.5) where most will have 1 product to 1 location (1). I need Excel to return a 1 or 0 based on if a new location is...- simned01
- Thread
- sequence warehouse
- Replies: 5
- Forum: Excel Questions
