View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JMod JMod is offline
external usenet poster
 
Posts: 1
Default deleting repeating cell values

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,