MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula to sort


Posted by rayn on August 13, 2001 11:24 PM

Hi

i have a huge list of names (1000 names) but some of them are repeated.
i would like to get all the names without a duplication.
i there a formula that does this.

Thank you for your help.

Regards
Rayn


Posted by Robb on August 13, 2001 11:34 PM

Rayn

If you use Advaneced Filter you can sort a list of unique names.

Just select Data/Filter/Advanced Filter
Enter the range to sort
Select Unique Records Only

You can filter the list where it is or choose to copy the result to another range.

Does that help?

Posted by Mark W. on August 14, 2001 6:21 AM

Filters don't sort

: Hi : i would like to get all the names without a duplication. : i there a formula that does this. : Rayn

Posted by Robb on August 14, 2001 5:09 PM

Re: Sorry - wrong terminology - for "sort" read "filter"