Posted to microsoft.public.excel.programming

Marc[_18_] Marc[_18_] is offline

external usenet poster

Posts: 1

macro find and delete duplicates in a spread sheet.

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find Duplicates Across Two Sheets, Delete Everything else.	waggett	Excel Worksheet Functions	2	October 6th 09 02:01 PM
delete a spread sheet	Mats	Excel Worksheet Functions	5	September 30th 09 10:03 PM
How do I find (not delete) duplicates in multiple spreadsheets?	Nelson[_2_]	Excel Worksheet Functions	1	June 1st 08 02:49 AM
Duplicates in a spread sheet	Martha	Excel Worksheet Functions	3	January 14th 08 05:18 PM
create a macro to search an excel spread for duplicates	jamalin	Excel Worksheet Functions	4	February 16th 07 10:58 AM

All times are GMT +1. The time now is 05:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us