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