Data Formatting
Hello All.
In excel, I need to keep the first row when it is followed by other
rows with the first two cells the same.
Therefo
CELLA CELLB CELLC
21 COMPANY TEXT VARIES - keep
21 COMPANY TEXT VARIES - delete
22 COMPANY TEXT VARIES - keep
22 COMPANY TEXT VARIES - delete
22 COMPANY TEXT VARIES - delete
23 COMPANY TEXT VARIES - keep
23 COMPANY TEXT VARIES - delete
23 COMPANY TEXT VARIES - delete
23 COMPANY TEXT VARIES - delete
Make sense?? Please help me.
|