why does my boss want this done?!!

[duckfoot]

I'm not sure if it can be easily done but I have a column 20000 or so rows long and have been asked to tidy it up. I have repeated data throughout the column and so (when i sort it) may have, say: 5 rows of xxxx, 16 rows of yyyy and then 1 row of zzzz, etc... I need to know how to quickly delete the repeated entries leaving just the first cell of a series of identical entries. Maybe a macro, or some lind of function... Please help. I can't go through it manually, it'll take a week!!!

 

[ldry]

On 2002-04-30 07:24, Asala42 wrote:
Hiya,

I see a lot of coding for this question but if you have the data sorted already, why not use a quick formula?

In an inserted blank column (starting with say A2): =if(B2=B1,"",B2)

Then copy/paste it over as values, then delete or hide the original column.

Adam

This is almost the same as what the Memicol/Amds macro does, and Amds suggested doing it manually if it's just a one-off.

Note : Asala42's suggested method will convert any formulas in the original column (if it is deleted) to values only - the Memicol/Amds method will retain any formulas.

To use the Memicol/Amds macro, you need to give it a name :-

Sub Whatever()
'Put the code here
End Sub
This message was edited by ldry on 2002-04-30 07:40

 

[duckfoot]

ADAM... YOU'RE A GENIUS!
Funny that its easy to overlook the simplest solutions.
Thanks alot