Hello, dear friends!
My question: I have a bulk of data in column A. I need to make a list of data in column B in the following way
A1 = Anna
A2 = Inga
A3 = Inga
A4 = Peter
A6 = Anna
A7 = Alex
I want to know what names are used (without finding out how many times it appears in column A) and to get a table in B column like this:
B1 = Anna
B2 = Inga
B3 = Peter
B4 = Alex
thank you very much.
From a tip by Ron De Bruin:
-------------------------------------
Data>Filter..Advanced Filter you can use
http://www.contextures.com/xladvfilter01.html#FilterUR
--
Regards Ron de Bruin
http://www.rondebruin.nl
------------------------------------
Use the instructions found at the website link above...
Set your "Copy to another location" to B1
Now all of the unique entries will be listed in Col B
HTH
Bruce
Last edited by swatsp0p; 05-05-2005 at 09:25 AM.
Bruce
The older I get, the better I used to be.
USA
Thank you very much.
Cheers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks