are you sure? to correct fotis you need =IF(COUNTIF($B$2:B2,B2)>1,"Doumple","ok"),
why didn't you just use the remove duplicates option on the data tab?
are you sure? to correct fotis you need =IF(COUNTIF($B$2:B2,B2)>1,"Doumple","ok"),
why didn't you just use the remove duplicates option on the data tab?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks