sorting wrong column

[orsm6]

Hi all - the formula below is returning the set of data I need, but it is sorting the column with player names descending rather than their scores descending - where am I going wrong?

=IFERROR(INDEX(SORT(FILTER(STATS!B5:F1000,(E5:E1000>0)*(STATS!A5:A1000=STATS!B2)),3,-1),SEQUENCE(5),{1,4}),"")

TIA

 

[orsm6]

sorry all - i just happened to work this out.

i tried to change this number before and I am sure it didn't work... but any way. I changed the value 3 in formula to 4 and it has worked.

=IFERROR(INDEX(SORT(FILTER(STATS!B5:F1000,(STATS!E5:E1000>0)*(STATS!A5:A1000=STATS!B2)),4,-1),SEQUENCE(5),{1,4}),"")

 

[StephenCrump]

You're sorting on column 3, which for the range B5:F1000 means D5:D1000. If that's not right, just change the 3.

BTW, not sure whether you should be testing: Stats!E5:E1000>0