I am using Excel 2003 SP3.
I have a column of text that contains several unique values:

AcmeCompany
Acme Company
ACME COMPANY

I want the user to see how many versions of their company name they have in
this column. I want to see all these entries in the auto-filter drop down,
but I only see the first two because of their spelling. Is there any way I
can accomplish this using autofilter? Any other ideas for displaying this
information to a user in a simple way?
I want to actually select the entire record that uses a particular spelling,
too, otherwise I would use Advanced Filter.
Thanks.
Jen G