Q: compare and replace in a workbook
I have data like this:
A B C
D E F G
121102
MENY DRØBAK
2004-11-30
PAR039
S550077
P144026
P40202
121102
MENY DRØBAK
2004-11-30
PAR040
S550077
P144026
P40202
121103
SPAR FOLKESTAD MAT
2004-11-30
PAR002
S550077
P144026
P40202
121103
SPAR FOLKESTAD MAT
2004-11-30
PAR003
S550077
P144026
P40202
121103
SPAR FOLKESTAD MAT
2004-11-30
PAR004
S550077
P144026
P40202
in an excel workbook.
What Id like to do is have a function or macro that replaces data with for
example "-" if column 1 has more than one instance of the same data.
Result should be like:
121102 MENY DRØBAK 2004-11-30 PAR039 S55077
P144026 P40202
- - -
- - - -
121103 SPAR FOLKESTAD MAT 2004-11-30 PAR002 S55077 P144026
P40202
- - -
- - - -
- - -
- - - -
I hope this is a good enough explanation.
regards
Arnfinn Hakkebo
|