Link to home
Start Free TrialLog in
Avatar of Melody Scott
Melody ScottFlag for United States of America

asked on

Why doesn't duplicate values work on this spreadsheet?

If I select both columns, then on the home tab select conditional formatting>duplicate values, fill with light red, I get no results. But meald shows up in both columns. Why would that not highlight? Using Office 2007.

test.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Just for future reference, you might want to add a PROPER() and a TRIM().
It would remove extra spaces and proper case text for example
"    mEald"
" meAld     "
"MEALD"

Open in new window

will all become
Meald

Open in new window

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Melody Scott

ASKER

Thanks, all, I hadn't thought of that.
Excellent, thanks!