Excel 2K and parsing data

[Ed]

I have a range of numbers (1-20) in multiple columns, but only 6 of them are
used in a particular column. As an example col1 would have 1,2,5,8,9,15;
col2 would have 6,7,8,10,15,20; etc. Since the numbers are entered in their
corresponding cell location (ie 1=B1, 2=B2, 5=B5, etc.) there are empty cells
between the numbers in the columns.

Is there a function that will take the numbers from each column, and parse
them to a range of six cells in another area of the spreadsheet? I'm looking
to have excel copy the numbers that have been entered, to another range and
not have blank cells between the numbers.

Thanx in advance...

 

[JE McGimpsey]

One way:

Select, say, Z1:Z6 and array enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=SMALL(A1:A20,{1;2;3;4;5;6})

 

[Ed]

Works like a champ!

"Big" thanx...

One way:

Select, say, Z1:Z6 and array enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=SMALL(A1:A20,{1;2;3;4;5;6})