Posted to microsoft.public.excel.programming
|
|
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
|