Splitting of data based on condition

**arurun** · 04-23-2012, 04:02 AM

Dear Expert,

I have 2 columns and few hundred thousand row of data. My first column has got the time and my second column has values. I have to split the data based on different timings that I have noted manually.

Eg)

Field1 Field2
4 0.05484
8 0.04985
12 0.04985
16 0.05484
20 0.04985
24 0.04985

I want to save data, based on the conditions say 12-20, 40-60, 1000-1020 onto 3 separate text file.

Thanks
Arun

**Bob Phillips** · 04-23-2012, 04:25 AM

Add a helper column, C, that determines the band. with a formula such as

=IF(A2<12,"0-11",IF(A2<21,"12-20",...

and then pivot the data.

**arurun** · 04-24-2012, 12:14 AM

Thank u.
But, I want an automated way through which I can save the data to text files.
Say, I give my condition to 12- 20, I want
12 0.04985
16 0.05484
20 0.04985
to be saved as a txt file
and I will be giving multiple conditions and everything has to be saved as separate text files

Thanks
Arun

**arurun** · 04-24-2012, 04:58 AM

To give more clarity, I am attaching my excel file (sample.xlsx). I have to split different segments(based on the first column values noted manually) and save each as a separate text file.
Thanks
Arun