Hi
How can I use filter function here to filter the max value in students marks columns.
I tried this but did not work
=FILTER(Table4[#Headers],Table4[Student Marks]=MAX(Table4[Student Marks]))
Any idea please. Thank you so much.
How can I use filter function here to filter the max value in students marks columns.
I tried this but did not work
=FILTER(Table4[#Headers],Table4[Student Marks]=MAX(Table4[Student Marks]))
Any idea please. Thank you so much.
Student Name | Student Marks |
Sam | 90 |
Agnes | 77 |
Ali | 96 |
Sebastian | 94 |
Winnie | 29 |
Kieth | 45 |
Wade | 15 |