icecreampie
New Member
- Joined
- May 28, 2024
- Messages
- 2
- Office Version
- 2021
- Platform
- Windows
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 ?