Select values in an array
 

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

Select values in an array
 

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

Select values in an array
 

Of course! Thanks very much.
--
sn


"Pete_UK" wrote:

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