Forum Discussion

tommills's avatar
tommills
Copper Contributor
Jan 07, 2019

Excel Help large data in inconsistent quantities

I have a data set of over 200,000 rows. It consists of certain parties (column A) and each their products (column B), however each party has a different amount of products. I need to filter out the parties that have the same product throughout so the parties that have different products are left, which will be investigated further. I don't want to have to look through every single row and party and identify which ones do have a consistent product and which ones do not. I think an IF formula of some kind is best but due to the inconsistent amount of products per party I struggle to know how to create such a formula. 

 

I have attached a simplified version. As an example I would like to know how to filter out parties A+C as they have the same product throughout.

 

Many thanks.

Resources