Sort Filter formula with multiple criteria

[creative999]

Hi,
I have a sort filter formula which works fine:
=IFERROR(INDEX(SORT(FILTER(SHEET1!A:Z,(SHEET1!J:J=A1)),4,-1),1,3),"--")

But when i try to add an additional criteria SHEET1!G:G is not blank im getting a '0' result.
=IFERROR(INDEX(SORT(FILTER(SHEET1!A:Z,SHEET1!G:G<>"",""),(SHEET1!J:J=A1),4,-1),1,3),"0")

Any suggestions?

 

[Cubist]

I think this is what you want. Try:

=IFERROR(INDEX(SORT(FILTER(SHEET1!A:Z,(SHEET1!G:G<>"")*(SHEET1!J:J=A1),""),4,-1),1,3),"0")

 

[creative999]

Perfect - works. Thank you so much