Thread: Duplicates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Guy Lydig Guy Lydig is offline
external usenet poster
 
Posts: 32
Default Duplicates

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