How to highlight duplicates entries?

December 18, 2012 at 21:50:43
Specs: Windows XP

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.qrst

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

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


See More: How to highlight duplicates entries?

Report •


#1
December 18, 2012 at 21:59:52

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

Report •

#2
December 18, 2012 at 23:20:59

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
46300093

2.69600090
69600090

3.46400090

4.50000173
50000173
50000173
50000173

5.46300093

6.65898999


Report •

#3
December 19, 2012 at 00:04:22

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.

Report •

Related Solutions


Ask Question