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
|