Click to See Complete Forum and Search --> : Excel Question


yiannakop
March 7th, 2006, 06:09 AM
Hi guys. I have the following question regarding MS Excel: I have a list (in one collumn) of names. I want to find (and delete) the duplicate names, and in a second column to present all the names (without any duplicates).

Any ideas how to do this?

Regards.
Theodore

wildfrog
March 7th, 2006, 06:26 AM
Here's some info on Advanced Filters
http://support.microsoft.com/?kbid=214324
http://www.meadinkent.co.uk/xlfilter.htm

- petter

yiannakop
March 7th, 2006, 08:15 AM
Thanx alot. It seems helpfull.