Duplicates Excel 2000
Use COUNTIF instead, comparing individual entries in G to the entire list.
Assuming your huge list goes from row 2 to 295, then try this as the formula
in row 2 and fill down:
=IF(COUNTIF(G$2:G$295,G2)=1,"No Duplicate")
"Dendy" wrote:
=IF(NOT(G2=G3), "No Duplicate")
I am using the above formula with a huge list. I have false on one of the
duplicates but would like to have false on both duplicates as I want to sort
all the false ascending to remove them at one time.
Thanks Linda
|