Hi,

Thanks for the quick response. I looked this up on the board and I saw a
neat solution using CountIf. Your solution looks easier but I can't make it
work unless I filter in place. What if I want to filter by column A but need
the data from columns B and C?

"OssieMac" wrote:

Hi Guy,

Select the data including the column headers (must have column headers) then
Data-Filter-Advanced and make a copy of Unique data. If you can't work out
how to drive Advanced filter then get back to me and let me know your version
of xl and I'll provide some instructions.

Note that the copy must be on the same worksheet.
--
Regards,

OssieMac


"Guy Lydig" wrote:

Excel XP

Column A has numbers which are repeated many times. Each number corresponds
to a family.

For example:

1234 Smith A
1235 Jones A
1234 Smith A
1236 Jones B
1234 Smith A
1235 Jones A
1234 Smith A
1236 Jones B

How can I extract each number listed only once (omitting duplicates) so I
have:

1234 Smith A
1235 Jones A
1236 Jones B

TIA

Guy