| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| randomly select a cell from an array | Excel Discussion (Misc queries) | |||
| Can I randomly select values from an array with removal? | Excel Discussion (Misc queries) | |||
| how do i select in aleatory way 3 numbers from an array of 10 | Excel Worksheet Functions | |||
| Array: Counting multiple values within array | Excel Worksheet Functions | |||
| Select sheets from an array for printing | Excel Discussion (Misc queries) | |||
Linear Mode
