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"
