Excelhelp111
New Member
- Joined
- Apr 29, 2014
- Messages
- 1
I have 1 column of data (4000 cells) and some are duplicates which have been located by True and False. The next step is to locate where all the duplicates are by a function that displays the exact cell(s) those duplicates are located. I do not know how to do the second step.
Just in case you need this...This is an example of my True/False Equation : =IF(E62="", "",(COUNTIF($E$60:$E$313,E62)>1))
Just in case you need this...This is an example of my True/False Equation : =IF(E62="", "",(COUNTIF($E$60:$E$313,E62)>1))