Filtering and sorting

[excelos]

Hello

I have this table:

A	B	C	D
1		3
4	5	7	3

I want to filter the table based on row 2 being non zero, then sort the array by row 3 (max to min) and then for each A, B, C, D, create the text "C has 3, A has 1" which is basically combining the values of row 1 and 2 into some text and consolidating them together after they have been sorted based on row 3.

Any idea?

Thanks!

 

[excelos]

Just to make an edit: I would like to sort not only by row 3, but by row 3 divided by row 2.

 

[jasonb75]

Is this what you want?

Book1
	A	B	C	D
1	A	B	C	D
2	1		3
3	4	5	7	3
4
5	C has 3, A has 1
6	C has 2.33333333333333, A has 4
Sheet2

Cell Formulas
Range	Formula
A5	A5	=TEXTJOIN(", ",1,SORT(IF(A2:D2<>"",A1:D1&" has "&A2:D2,""),,-1,1))
A6	A6	=TEXTJOIN(", ",1,SORT(IF(A2:D2<>"",A1:D1&" has "&(A3:D3/A2:D2),""),,-1,1))