Select values in an array

[scott]

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

 

[Pete_UK]

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

 

[scott]

Of course! Thanks very much.
--
sn

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