I have a spreadsheet with thousands of product records. Some have RRP and then Offer Price and others do not. What I want to do is to remove all the records where the price in the RRP column and Offer Price Column are the same.
Answers (1)
Consider the price in RRP is in Column A, and Offer Price Column is Column B.
Then write in Column C the below formula:
=EXACT(A:A,B:B)
This will return TRUE if the value in both the columns are same, and FALSE if they are different. Then you can filter the columns having value as "TRUE" and delete all those.