deleting repeating cell values

  • Thread starter Thread starter JMod
  • Start date Start date
J

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,
 
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,
|
 
Back
Top