Posted to microsoft.public.excel.programming

external usenet poster

Posts: 4

HELP delete duplicate rows.

I have a spreadsheet with lots of duplicate rows of data.
I have run =IF(COUNTIF($A$2:A2,A2)=1,"-","Delete") to see
where duplicates appear and this is fine. I have 1,576
records of which I only need to keep 645.

What I would like to know is, how would I run a macro to
delete any rows automatically and move the the deleted
lines up so there are no blank lines between the remaining
information?

Any help is greatly appreciated.

Many thanks

Malcolm

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
delete duplicate rows, keep one	Wasdell	Excel Discussion (Misc queries)	1	October 30th 09 12:16 PM
Delete rows with duplicate values	One-Leg	Excel Discussion (Misc queries)	1	February 17th 08 06:49 PM
delete duplicate rows	christinaLO	Excel Worksheet Functions	1	February 27th 07 06:22 PM
Delete duplicate rows	christina	Excel Programming	1	August 4th 03 01:04 PM
delete duplicate rows	rhys	Excel Programming	2	July 29th 03 12:52 PM

All times are GMT +1. The time now is 03:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us