han77729
New member
- Joined
- Dec 12, 2012
- Messages
- 31
- Reaction score
- 0
- Points
- 0
Hello all,
I'm trying to compare a POS data from last month to POS data from this month. (I have both POS data in the same workbook, in separate sheets) These POS data consist of multiple columns as such (Customer, part number, part type, shipping date, etc..) What I'm trying to do is identify the new part numbers that the existing customers from last month are buying, from this month's data.
I've done a similar command before where I'm locating new customers from the new POS data comparing to the old POS data.(and it works!)
This is the formula I used =IF(ISNA(MATCH(Table1[[#This Row],[Customer]],ExistingCustomer,9)),"NewCustomer","Old")
Maybe this formula will five you a direction of what I'm trying to do, which is comparing. Comparing current part numbers that doesn't overlap previous month's part number for each customer. (To identify new part # old customers are ordering)
Hope this makes sense,
Han
I'm trying to compare a POS data from last month to POS data from this month. (I have both POS data in the same workbook, in separate sheets) These POS data consist of multiple columns as such (Customer, part number, part type, shipping date, etc..) What I'm trying to do is identify the new part numbers that the existing customers from last month are buying, from this month's data.
I've done a similar command before where I'm locating new customers from the new POS data comparing to the old POS data.(and it works!)
This is the formula I used =IF(ISNA(MATCH(Table1[[#This Row],[Customer]],ExistingCustomer,9)),"NewCustomer","Old")
Maybe this formula will five you a direction of what I'm trying to do, which is comparing. Comparing current part numbers that doesn't overlap previous month's part number for each customer. (To identify new part # old customers are ordering)
Hope this makes sense,
Han