Thread: Data Formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Programmer wanna be Programmer  wanna be is offline
external usenet poster
 
Posts: 5
Default 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.