Eliminating Duplication?

sj1601

Board Regular
Joined
Aug 12, 2006
Messages
96
My data column:

John
John
Smith
Smith
Mary
Mary
Mary

and so on (runs into several hundred rows)

I want to reduce this column so that I avoid duplicates. Therefore just one entry for John, Smith etc.

Any suggestions?

Thanks.

sj1601
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,905
Office Version
  1. 365
Platform
  1. Windows
Check out the Unique Records Only option under Advanced Filters (Data | Filter | Advanced Filter...)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,403
Messages
5,547,750
Members
410,811
Latest member
adustin42
Top