This will not work for my purposes. The Advanced Filter considers every row
to be a record and so filters by column to return the row. My sheet is a
seating chart where every cell is a record so I can't filter this way.

Ashish Mathur wrote:
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

I have a spreadsheet where Sheet A contains names (including duplicates)
in a
[quoted text clipped - 3 lines]
Thanks,
Dave

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1

Hi,
If you wish, you may mail the file to me at ask(at)ashishmathur(dot)com.
Please explain the problem very clearly and give before/after examples.
Also, please ensure that the file size is not large (kindly remove redundant
information).

Thank you.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"golddave via OfficeKB.com" <u54833@uwe wrote in message
news:9c3ab23840981@uwe...
This will not work for my purposes. The Advanced Filter considers every
row
to be a record and so filters by column to return the row. My sheet is a
seating chart where every cell is a record so I can't filter this way.

Ashish Mathur wrote:
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

I have a spreadsheet where Sheet A contains names (including duplicates)
in a
[quoted text clipped - 3 lines]
Thanks,
Dave

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1