Look for the highest number

[Rye]

Hi Guys, is there a way to get the highest number automatically? please see the table below. Thank you for always helping us.

Meters	Score	High score
0	0	21
2	20
3	1
8	2
9	5
10	10
11	2
20	3
Is there a way to get the highest value automatically in this equation?
* My goal is to look for the highest score within 1 meter
* in this example, the highest score is 21
* Please note that, only the highest score will be recorded.

 

[Rye]

Thanks for now using XL2BB. For the future, when you do that, don't put your instructions in the worksheet, just write them separately in your post (like I have with this message)

Looks like I was over-complicating it in the first place. What about this instead?

23 05 21.xlsm
	A	B	C
1	Table 1.1
2	Meters	Score	High Score
3	0	0	21
4	2	20
5	3	1
6	8	2
7	9	5
8	10	10
9	11	2
10	20	3
11
12	Table 1.2
13	Meters	Score	High Score
14	0	0	20
15	2	20
16	4	1
17	8	2
18	10	5
19	12	10
20	14	2
21	20	3
Sheet2 (3)

Cell Formulas
Range	Formula
C3,C14	C3	=LET(r,A3:A10,MAX(SUMIFS(B3:B10,r,">="&r-1,r,"<="&r+1)))

Hi @Peter_SSs, this one here is perfect. I appreciate your prompt response, really do. Cheers!!!!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.