Filter function - based on max value in another columne

[INN]

Hi
I have this table what I want is to filter the max mark so I wrote this formula but did not work

=FILTER(A1:B16,MAX(B1:B16))

Any idea would be very much appreciated. Thank you.

Student Name	Student Marks
Sam	90​
Agnes	77​
Ali	96​
Sebastian	94​
Winnie	29​
Kieth	45​
Wade	15​
George	93​
Chad	93​
Jacqueline	55​
Quinn	90​
Nicole	33​
Raj	74​
Ron	100​
Tao	56​

 

[kevin9999]

Just make sure the Student Marks are actual numbers & not text.

Book1
	A	B
1	Student Name	Student Marks
2	Sam	90
3	Agnes	77
4	Ali	96
5	Sebastian	94
6	Winnie	29
7	Kieth	45
8	Wade	15
9	George	93
10	Chad	93
11	Jacqueline	55
12	Quinn	90
13	Nicole	33
14	Raj	74
15	Ron	100
16	Tao	56
17
18	Ron	100
19
Sheet1

Cell Formulas
Range	Formula
A18:B18	A18	=FILTER(A2:B16,B2:B16>=LARGE(B2:B16,1))
Dynamic array formulas.

 

[Biz]

Try formula below
In Cell E2 =FILTER(A2:B16, B2:B16 = MAX(B2:B16))

Kind Regards

Biz