| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compare data in multiple columns
I have data in this format, I want to know what is the diff of quantity between warehouse and the store, storewise
Warehouse ItemId ItemDesc StoreId Qnty i101 ItemA str21 9 i201 itemB str21 8 i101 ItemA str25 7 i201 itemB str25 9 Store ItemId StoreId Qnty i101 str21 5 i101 str25 3 i201 str21 2 i201 str25 3 Thanks in advance... |
|
#2
|
|||
|
|||
|
Quote:
Hi, Could you clarify a few points...? What you asking is for the number difference of any given item between store and warehouse? So you want to know how many more/less of each item there are in each store than there are in the warehouse? Also, which version of Excel are you using? |
|
#3
|
|||
|
|||
|
Quote:
|
|
#4
|
|||
|
|||
|
Quote:
|
|
#5
|
|||
|
|||
|
Quote:
|
|
#6
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Perform compare of multiple selected columns | Excel Programming | |||
| Compare multiple columns-----siva and surya | Excel Worksheet Functions | |||
| Compare multiple columns in two workbooks? | Excel Programming | |||
| compare multiple columns | Excel Discussion (Misc queries) | |||
| Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
Linear Mode
