Hi Rey,
That will tell you which cells are in lower case, but not which lower-case cells are duplicates of upper-case cells:
Quote:
|
I need to remove the duplicate rows that have the ID letters lowercase and I need to keep the ID's with uppercase letters.
|
You still haven't said what range the data spans. As it now appears to span part or all of Column B, you could use a formula like:
=TRIM(IF(COUNTIF(B$1:B1,B1)> 1,"Duplicate","")&" "&IF(EXACT(B1,LOWER(B1)),"Lower Case",""))
if you put the above formula in, say, D1 and copy it down as far as needed, it will report both duplicates (regardless of case) and lower-case forms (regardless of duplication).