How to find duplicate names in different rows
Posted by Jonathan on June 20, 2001 2:21 PM
I have a rather perplexing one here. I have a spreadsheet that is rather large (will get up to 12000 rows). I need to match the criteria in 3 columns to see if I have duplicates in rows. Data sort works, but I must scroll down the entire spreadsheet to find a dupe by row after it's been sorted. Example:
columna a (lastname), column b (firstname), column c (customerid), column d-w (misc. info).