Add Last 36 row of data with other condition exclude Zero

Hi There,

Need help, I like to find the last 36 score in the spreadsheets but with the following conditions:

1. Name
2. Exclude Zero


Please see the attached example and appreciate your help.

I did a search and found the index can do it, but can't figure out how to have the condition with the "name" and "exclude zero"

Thanks a lot
Raymond

Please tell us the results you are expecting to see (manually calculated) in the yellow cells.

Please try at

L16
=INDEX(Table1[Score],AGGREGATE(14,6,ROW(Table1)/(Table1[Name]=$H$3),$H$4-ROWS(L$16:L16)+1)-ROW(Table1[#Headers]))

M16
=INDEX(Table1[Score],AGGREGATE(14,6,ROW(Table1)/(Table1[Name]=$H$3)/(Table1[Score]>0),$H$4-ROWS(L$16:L16)+1)-ROW(Table1[#Headers]))