Thread: Continious Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TFMR TFMR is offline
external usenet poster
 
Posts: 24
Default Continious Data

Dear All,

I have file with data, I want to delete continious data in that report:
e.g.

Start
Stop
Start
Start
Start
Stop
Start
Stop
Stop
Stop

If continious Start then keep last and change previous Start with "null" and
if continious Stop then keep first Stop and remaining change with "null".

Thanks & Regards

Hassan