Russ At Index
Well-known Member
- Joined
- Sep 23, 2002
- Messages
- 706
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Good afternoon ,
I have a list which is made up of three months of data:
A B C D
Date Sku Location Picked
Jan-22 1245 01-01-10 15
Feb-22 1225 02-14-25 10
Mar-22 1245 01-02-20 15
Mar-22 1225 02-14-25 100
There are many records that have the same sku against many different over the three months .
What I would like & am struggling to get to ……is a table of only sku’s that have had the same location over the three months .
Result looking like ….. Sku 1225 has had the same location 02-14-25 & the qty picked is 110
Any help appreciated ,
Russ.
I have a list which is made up of three months of data:
A B C D
Date Sku Location Picked
Jan-22 1245 01-01-10 15
Feb-22 1225 02-14-25 10
Mar-22 1245 01-02-20 15
Mar-22 1225 02-14-25 100
There are many records that have the same sku against many different over the three months .
What I would like & am struggling to get to ……is a table of only sku’s that have had the same location over the three months .
Result looking like ….. Sku 1225 has had the same location 02-14-25 & the qty picked is 110
Any help appreciated ,
Russ.