Sorry, thought I'd work in upper case, then forgot to include that in the COUNTIF.... This might solve the problem
=IF(COUNTIF($E$2:E2,UPPER(E2))>1,"Duplicate","")
Sorry, thought I'd work in upper case, then forgot to include that in the COUNTIF.... This might solve the problem
=IF(COUNTIF($E$2:E2,UPPER(E2))>1,"Duplicate","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks