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 post to 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
500001735.46300093
6.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.
