Sort non blank cells

[eduzs]

I need to list the non blank cells in order they appear: (. = blank line/cell)

.
A
.
.
C
.
.
F

3 lines with:

A
C
F

Thanks

 

[eduzs]

explaining better:

I have this:

1
2	A
3
4
5	B

<tbody>
</tbody>

Need a formula to show this in an another area of the sheet:

2	A
5	B

<tbody>
</tbody>

So the formula must get the number in column A when column B is not blank
In column B i will use VLOOKUP easy, but wich formula to use in Column A?

 

[AhoyNC]

See if this gives what you want.

Formula in D2 is an array formula and must be entered with

Excel Workbook
	A	B	C	D	E
1	#			#
2	1			2	A
3	2	A		5	B
4	3
5	4
6	5	B
7
CTRL-SHIFT-ENTER. Sheet3

[/B]

 

[eduzs]

Just needed to change ISBLANK...=0 to $F$4:$F$17<>"" (Cause the cells have formulas =""), works great.

Thanks!

 

[Peter_SSs]

If you would prefer a non CTRL-SHIFT-ENTER formula and you are using Excel 2010 or later, an alternative is:

Excel Workbook
	A	B	C	D	E
1
2	1			2	A
3	2	A		5	B
4	3
5	4
6	5	B
7
Exclude Blanks

 

[eduzs]

Thanks! I was also looking for a non-matrix formula.
Works great.