You could just apply Autofilter to the 4th column and select each
value in turn, then copy/paste the visible rows for each value into a
new sheet.

Hope this helps.

Pete

On Sep 8, 11:31*pm, scott wrote:
From the following array, I wish to create 3 new arrays, based on the 3
values in the 4th column.

0 * * * 1 * * * 1 * * * 1 * * * 0.00E+00 * * * *0.00E+00 * * * *0.00E+00
0 * * * 1 * * * 1 * * * 2 * * * 0.00E+00 * * * *0.00E+00 * * * *0.00E+00
0 * * * 1 * * * 1 * * * 3 * * * 0.00E+00 * * * *0.00E+00 * * * *0.00E+00
0.08 * *1 * * * 1 * * * 1 * * * 4.37E-08 * * * *8.94E-07 * * * *8.61E-08
0.08 * *1 * * * 1 * * * 2 * * * 4.37E-08 * * * *8.94E-07 * * * *8.61E-08
0.08 * *1 * * * 1 * * * 3 * * * 4.37E-08 * * * *-1.67E-15 * * * 8.61E-08
0.2 * * 1 * * * 1 * * * 1 * * * 4.81E-07 * * * *8.05E-06 * * * *4.05E-07
0.2 * * 1 * * * 1 * * * 2 * * * 4.81E-07 * * * *1.16E-05 * * * *4.05E-07
0.2 * * 1 * * * 1 * * * 3 * * * 4.81E-07 * * * *-4.47E-06 * * * 4.05E-07

--
sn