Need help with a formula to exclude the last row with a data

[icecreampie]

So, I'm currently using =LARGE($H$39:$H$76;I11) to take a data for like a top 10 for biggest percentage, is there any way to make it like into from row h39 to like 1000 and just ignore the last cell row with a data so when the new data is filled in that row it just ignore the last filled data is the total and it will skewed the result because it will include the total as the total ?

 

[Phuoc]

Maybe like this:

=LARGE($H$39:$H$1000;I11 + 1)

 

[icecreampie]

Maybe like this:

=LARGE($H$39:$H$1000;I11 + 1)

it worked thank you, was trying some more like weird formula and it didn;t worked, thank you very much

 

[kvsrinivasamurthy]

ARRAY formula

=LARGE($H$39:INDEX($H$39:$H$100,MATCH(FALSE,$H$39:$H$100<>"",0)-2),I11)

To enter ARRAY formula
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.