deleting repeating cell values

[JMod]

I have a sheet with 33,000 rows.

All records are unique as it is when considering Column B
But each value in Column A is repeated 2 -4 times.

Is there a way I can delete the rows where A is being repeated?

For Example

A | B
Mar | Jon
Mar | Per
Smi | que
Smi | tic

would become

Mar | Jon
Smi | que

Thanks,

 

[Niek Otten]

http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a sheet with 33,000 rows.
|
| All records are unique as it is when considering Column B
| But each value in Column A is repeated 2 -4 times.
|
| Is there a way I can delete the rows where A is being repeated?
|
| For Example
|
| A | B
| Mar | Jon
| Mar | Per
| Smi | que
| Smi | tic
|
| would become
|
| Mar | Jon
| Smi | que
|
| Thanks,
|