MikeMCSD
asked on
How to select the Distinct values of a Column.
I have columns that have repeating values for the rows, like "Ear Care, Pain Relief, Joint Care, Bathing".
Is there a way I get a list of all these distinct values?
(I want a list of all the values without them repeating)
It would be like using "Select Distinct . ." in SQL.
Please explain how to do it using simple steps because I don't use Excel at all
and don't even know to do simple things.
Thanks
Is there a way I get a list of all these distinct values?
(I want a list of all the values without them repeating)
It would be like using "Select Distinct . ." in SQL.
Please explain how to do it using simple steps because I don't use Excel at all
and don't even know to do simple things.
Thanks
ASKER
thanks, but I need a "plug this in there" because like I said, I don't know $#@% about Excel.
I know one thing about Excel : I hate it.
I know one thing about Excel : I hate it.
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.
I like GlennLRay's answer better. :-)
ASKER
thanks guys
http://www.cpearson.com/ex
Hope that helps!