dreid1011
Well-known Member
- Joined
- Jun 4, 2015
- Messages
- 3,605
- Office Version
- 365
- Platform
- Windows
I recently helped on this thread:
https://www.mrexcel.com/forum/excel-questions/1045469-between-if-excel-formula-help.html
post #10 with my suggested solution
I feel like there should be a more compact way to use PERCENTILE/AGGREGATE in this manner. However, when I tried to use INDEX/MATCH inside {} to establish the upper and lower bounds of the array, Excel would have none of it.
I am not against using helper cells/columns, it just feels like I COULD have come up with something in a single cell.
Any and all thoughts on this are most welcome.
Thank you.
https://www.mrexcel.com/forum/excel-questions/1045469-between-if-excel-formula-help.html
post #10 with my suggested solution
I feel like there should be a more compact way to use PERCENTILE/AGGREGATE in this manner. However, when I tried to use INDEX/MATCH inside {} to establish the upper and lower bounds of the array, Excel would have none of it.
I am not against using helper cells/columns, it just feels like I COULD have come up with something in a single cell.
Any and all thoughts on this are most welcome.
Thank you.