Need help with formula

[Russk68]

Hi All
I use an array formula that takes values that are spread out in a column and condenses the values in another column but it doesn't work with numbers.

Example
In column A there are 5 numbers spread out with spaces in between rows 1 thru 10.
I need the first 5 rows in column B to show those numbers.

Hope that makes sense.

Thank you!

Russ

 

[oldbrewer]

=large($a$1:$a$10,1) finds the largest etc

=if(iserror(large($a$1:$a$10,6)),"",large($a$1:$a$10,6) will return blanks instead of error messages

the 1 thru 10 could be out of the way in AA1 to AA10 so 1 in first example would be replaced by AA1

 

[Russk68]

Hi and thank you for your help.
I copied the 2nd formula but doesn't result anything.
I don't think I need a large formula here. The example below might explain a little better. (ignore the .....) I just need to compress the numbers in column A into column B. Column B needs the formula.

.....A.........B
1...15.......15
2..............3
3...3.........27
4..............4
5
6...27
7
8...4

Thanks!

 

[admiral100]

Hi,

Try this:-

Ctrl+Shift+Enter NOT just Enter

B1 =IFERROR(INDEX($A$1:$A$10,SMALL(IF($A$1:$A$10<>"",ROW($A$1:$A$10)),ROWS(B$1:B1))),"")

 

[Russk68]

Perfect!

Thank you all!!!

 

[admiral100]

You are welcome.