View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default macro find and delete duplicates in a spread sheet.

Hi
see
http://www.cpearson.com/excel/deleti...eDuplicateRows

--
Regards
Frank Kabel
Frankfurt, Germany


Marc wrote:
Hi,

Does anyone know, or point me in the right direction, how to have
Excel find duplicate cells and delete them. For example, I have 2
columns of numbers. I need Excel to read the first cell in column A
and look for a match in column B, and if it finds it, delete both.
Then to repeat for the whole column. Any help would be appreciated.

Thanks,
Marc