Melody Scott
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
test.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, all, I hadn't thought of that.
ASKER
Excellent, thanks!
It would remove extra spaces and proper case text for example
Open in new window
will all becomeOpen in new window