Filter by column "Unit" to get filter "Highest " value

[CScottP]

UNIT	VALUE
A	0
A	1
A	2
B	0
B	1
B	2
C	0
C	1
C	2
C	3
D	0
D	1
D	2
D	3
D	4
D	5
D	6

Expected reults:
A	2
B	2
C	3
D	6

[vivek31]

HI @CScottP ,

you can you use MAX function 
Highest = MAX(Table[Value])

[Syk · Accepted solution]

Max Value = MAX(Table[Value])