Hi,
You could be on any cell in sheet2. Go to Data Filter Advanced Filter.
In the action section, select copy to another location. In the list range,
select the range on sheet1. Leave the criteria range blank and in the copy
to box, select the active cell. Check the box for unique records only. Now
click on OK. This will extract the unique records.
You may now sort the data
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"golddave" <u54833@uwe wrote in message news:9c37205cf55b6@uwe...
I have a spreadsheet where Sheet A contains names (including duplicates)
in a
range. I'd like Sheet 2 to list the distinct names in alphabetical order.
Any ideas?
Thanks,
Dave