How can I autofill a find duplicates formula?

by robys . Updated 14 years, 8 months ago

Formula is:
=IF(COUNTIF(D$2:D$2,D2)>1,”Duplicated”,””)
=IF(COUNTIF(D$2:D$3,D2)>1,”Duplicated”,””)
=IF(COUNTIF(D$2:D$4,D2)>1,”Duplicated”,””)

This discussion is locked

All Comments