Forum Discussion

Copper Contributor

Jul 19, 2022

Solved

Trying to use "If" array to pull data in order from highest stat to lowest

My starting formula for Q2 is: =if (K2=$B2,$B$1,(if(K2=$C2, $C$1,(if(K2=$D2,$D$1,(if(K2=$E2,$E$1,(if(K2=$F2,$F$1,(if(K2=$G2,$G$1,"false")))))))))) This gives me the first value associated with ...

excel

Formulas and Functions

Rsartori76
Jul 19, 2022
Mr_FunGuy
In Google Sheets I was able to reproduce it with this formula:

=TRANSPOSE(INDEX(SORT(TRANSPOSE(A1:F2),2,0),,1))

Mr_FunGuy

Copper Contributor

Jul 19, 2022

Using Google sheets... How about a SortN function??

Rsartori76

Brass Contributor

Jul 19, 2022

Mr_FunGuy

In Google Sheets I was able to reproduce it with this formula:

=TRANSPOSE(INDEX(SORT(TRANSPOSE(A1:F2),2,0),,1))

Mr_FunGuy
Copper Contributor
Jul 20, 2022
Thanks! I ended up using the following:

=TRANSPOSE(INDEX(SORT(TRANSPOSE({$B$1:$G$1;B2:G2}),2,0),,1))

Thanks a ton!
Mr_FunGuy
Copper Contributor
Jul 20, 2022
that does work for the first row, thanks! how would i make that able to drag down 10000 rows? i'm gonna be dealing with many thousands of enteries