dup value deletion

I

italiavb

Hi,

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

1120
7 May 07

1120
9 May 07

1120
9 May 07

1140
6 June 06

1140
15 July 07

1160
1 Jan 05

1160
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro for duplicate values 0
Select value on a cell by matching value of two cells 1
Removing duplicates but leaving data on following rows 8
Range.Find problem 3
Assigning values to dates 7
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Macro to filter two columns 8
Determining Change in a cell Value.... 4

Top