I have a large excel file where I have to do some data screening.
- Lets say that Column A represent a car brand
e.g. Toyota, Jaguar etc
- Column B represents name of spare part
e.g. Brake disks
- Column C represents shelve in a ware house
I want to screen the excel sheet to ensure that e.g. all brake disks for Toyota is stored on the same shelve. Basically I want to be able to flag any part that are stored over several locations i.e. for a given combination of values for column A and B there is more than one value in column C.
There are no free text fields to all naming will be consistent but there are 120,000 rows so rather large file.
Please note that e.g.
Toyota - Brakes - R10S12A
can share location with e.g.
Porsche - Clutch - R10S12A
This is OK, I just want to know if any give value in A&B (e.g. Porsche - Clutch) would return more than one value in column C.
Edit: Error code when trying suggested solution below: