Please help! Conditional formatting & filtering

Occasional Visitor
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!!
1 Reply

@Kfelux If you have dynamic arrays then I think this will work:


or without this should work if you paste and copy down 


 NOTE in both cases performance can be improved if you use actual ranges instead of the entire column.