Column searching using macro or VB

  • Thread starter Thread starter Tom Ogilvy
  • Start date Start date
T

Tom Ogilvy

You can get a list of unique entries using the Advanced filter and checking
the Unique only box. Turn on the macro recorder while you do it manually.
Then modify the code to make any modifications you need. you can then clear
the original, copy the uniques back on top, delete the uniques that you
copied.
 
We're pretty good at writing macros but not that good.
We a have columns containing duplicate information - for example:
A
A
A
C
C
F
F
F
F and so on
We're trying to write macro that will "simply" say; if a value in the
column exists then copy it to the next column, but only copy it once (we
only need to know if it appears once not x number of times in a column. OR
goto the first cell; its value is "A" ; search the rest of the column for
"A" , delete all OTHER instances of "A" (but keep the first instance); then
go to cell below that and do the same. The column can then be sorted to
produce this:
A
C
F and so on

Any assistance would be greatly appreciate
Thanks
Richard
 
Back
Top