Looking formula which can bring highest value against specific number from multiple lines as shown below

[Babar Razzaq]

Date	Fleet#	Hour Meter			Fleet​	Values​
Thu, Mar 23, 2023​	1​				1​	39646​
Thu, Mar 23, 2023​	1​				2​	41526​
Thu, Mar 23, 2023​	1​				and so on​
Fri, Mar 24, 2023​	1​
Fri, Mar 24, 2023​	1​
Fri, Mar 24, 2023​	1​
Sat, Mar 25, 2023​	1​	39583​
Sun, Mar 26, 2023​	1​	39592​
Mon, Mar 27, 2023​	1​	39604​
Mon, Mar 27, 2023​	1​	39615​
Tue, Mar 28, 2023​	1​
Wed, Mar 29, 2023​	1​	39625​
Thu, Mar 30, 2023​	1​	39635​
Fri, Mar 31, 2023​	1​	39646​
Fri, Mar 24, 2023​	2​	41500​
Sat, Mar 25, 2023​	2​	41514​
Sat, Mar 25, 2023​	2​	41506​
Mon, Mar 27, 2023​	2​	41526​

 

[AhoyNC]

Try:

Book2
	A	B	C	D	E	F	G
1	Date	Fleet#	Hour Meter			Fleet	Values
2	Thu, Mar 23, 2023	1				1	39646
3	Thu, Mar 23, 2023	1				2	41526
4	Thu, Mar 23, 2023	1				and so on
5	Fri, Mar 24, 2023	1
6	Fri, Mar 24, 2023	1
7	Fri, Mar 24, 2023	1
8	Sat, Mar 25, 2023	1	39583
9	Sun, Mar 26, 2023	1	39592
10	Mon, Mar 27, 2023	1	39604
11	Mon, Mar 27, 2023	1	39615
12	Tue, Mar 28, 2023	1
13	Wed, Mar 29, 2023	1	39625
14	Thu, Mar 30, 2023	1	39635
15	Fri, Mar 31, 2023	1	39646
16	Fri, Mar 24, 2023	2	41500
17	Sat, Mar 25, 2023	2	41514
18	Sat, Mar 25, 2023	2	41506
19	Mon, Mar 27, 2023	2	41526
Sheet1

Cell Formulas
Range	Formula
G2:G3	G2	=MAXIFS(C2:C19,B2:B19,F2)

 

[AhoyNC]

In the formula above you need to lock the cells.
MAXIFS($C$2:$C$19,$B$2:$B$19,F2)