Hi,

I have list of some 26000 entries in an excel sheet and I have to find out the duplicates or multiples in this list.Example:

1.abcd

abcd

abcd

2.efgh

3.ijkl

4.abcd

5.mnop

mnop

6.qrstFrom the above data,the duplicate entry of num 4 need to be highlighted.

Any idea on how to do it instead of using COUNTIF?

Hi

its not clear to me why "entry of num 4" is a duplicate. Could you use these instructions ---How to postto paste a sample of data from a worksheet.

Hi AlteK, I have a set of data contains id nums of product. The set of data of no 5 is the duplicate of data no 1. How to identify and highlight the duplicate value?

1.46300093

46300093

46300093

46300093

463000932.69600090

696000903.46400090

4.50000173

50000173

50000173

50000173

5.463000936.65898999

Is this what your data really looks like? Rows 2,3,4,5 are duplicates as are the rows containing 50000173 Don't you want to highlight them? Where you have 5.46300093 is that how the data appears? I can't answer based on what you've shown.

Ask Your Question

Weekly Poll