katrinocka
New Member
- Joined
- Sep 8, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello, I am struggling with quartile formula to calculate the selected value in another tab based on the description and grade. In the workbook I have one tab with all the data range based on description (i.e. Maths - A, B, C) and in another tab I need to calculate 3rd quartile for grade A, B and C based on range of data for Maths. I understand that the quartile formula if I were to select grades manually is =QUARTILE(Maths!1:18),3), however, is there a formula that I can automatically set up for it to search quartile for Maths, Geography or any other description and and base it on the grade as well?