Sort "Z to A" but keep "blank" values at bottom of list

[smking204]

I want to build a macro to sort rows 2-50 by column D, descending (Z-A). But Column D contains formulas that remain blank unless sufficient data appears in columns A and B. How can I sort rows 2-50 in descending order without getting the "empty" cells appearing on top and pushing all the relevant cells to the bottom?

 

[lrobbo314]

How about something like this... Just formulas, no VBA.

XL
	N	O	P	Q	R
1	A	1		O	15
2	B			M	13
3	C	3		K	11
4	D			I	9
5	E	5		G	7
6	F			E	5
7	G	7		C	3
8	H			A	1
9	I	9		B
10	J			D
11	K	11		F
12	L			H
13	M	13		J
14	N			L
15	O	15		N
Data

Cell Formulas
Range	Formula
Q1:R15	Q1	=LET(table,N1:O15,sort_col,O1:O15,sb,IF(sort_col="",-1,sort_col),SORTBY(table,sb,-1))
O1:O15	O1	=IF(MOD(ROW(),2)=0,"",ROW())
Dynamic array formulas.

 

[smking204]

How about something like this... Just formulas, no VBA.

XL
	N	O	P	Q	R
1	A	1		O	15
2	B			M	13
3	C	3		K	11
4	D			I	9
5	E	5		G	7
6	F			E	5
7	G	7		C	3
8	H			A	1
9	I	9		B
10	J			D
11	K	11		F
12	L			H
13	M	13		J
14	N			L
15	O	15		N
Data

Cell Formulas
Range	Formula
Q1:R15	Q1	=LET(table,N1:O15,sort_col,O1:O15,sb,IF(sort_col="",-1,sort_col),SORTBY(table,sb,-1))
O1:O15	O1	=IF(MOD(ROW(),2)=0,"",ROW())
Dynamic array formulas.

Not a fan. Thanks though. I've got it set up the way I want it, and usually I do the sort myself by manually selecting the relevant range (usually about 15 to 20 rows) and going to Data > Sort, but I want to create a button to do that automatically, and apply it to all rows through 50, since the length of the list changes according to row A. Just looking for a way to make sure the empty rows remain at the bottom when I sort rows 2-50.