LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 6th 07, 01:14 AM posted to microsoft.public.excel.programming
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 19
Default dup value deletion


Column A has number values with several duplicates and I want to keep
the first time the number value appears along with it's adjancent cells
value and delete all other instances of the number.

Example: column A
column B

7 May 07

9 May 07

9 May 07

6 June 06

15 July 07

1 Jan 05

15 march 06

I would like to run a macro that looks in Column A, finds the first value,
brings back the adjacent value in column B. Then either skips over or
deletes the duplicate 1120's and stops at 1140 and bring it's adjacent cells
value, skips the next 1140.etc. Any ideas?

Thanks, Italiavb

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
#Ref! after row deletion Rick Excel Discussion (Misc queries) 3 March 19th 10 04:39 PM
Record deletion DDD Excel Worksheet Functions 1 December 8th 08 02:05 PM
name deletion rk0909 Excel Discussion (Misc queries) 2 January 4th 08 11:03 PM
Bulk row deletion quartz[_2_] Excel Programming 1 November 9th 04 05:00 PM
Row Deletion Dan Excel Programming 3 September 1st 04 10:40 PM

All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017