I need help on comparing 2 columns in an excel spreadsheet and see which of those columns have duplicate cells. I keep looking different functions open, but it is not working for me. I have done this before, but forgot the formula.
You can use Conditional Formatting or you can use a variety of functions such as COUNTIF, VLOOKUP, INDEX(MATCH), etc. Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.