Hi Rey,

That will tell you which cells are in lower case, but not which lower-case cells are duplicates of upper-case cells:


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).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]