I'm a total novice when it comes to excel. I have 3 columns of data. In column A & C, I have lists of account #s. I have an ID # listed in column B. I applied conditional formatting in columns A & C to identify duplicates. What I need to find now is the value in column B, whenever the value in column C is identified as a duplicate. Problem is, I have over 120k rows of data so I can't filter! Hopefully this makes sense, would really appreciate any help!!