Help with rank and difference.

[Davebro]

I am looking to find the highest number from A and then find the difference between the top and the other numbers. A is the time which varies, B is the number.

14:00:00​	170​	0​
14:00:00​	164​	6​
14:00:00​	163​	7​
14:00:00​	162​	8​
14:00:00​	161​	9​
14:00:00​	159​	11​
14:00:00​	158​	12​
14:00:00​	157​	13​
14:00:00​	155​	15​
14:00:00​	155​	15​
14:00:00​	150​	20​
14:30:00​	168​	0​
14:30:00​	159​	9​
14:30:00​	155​	13​
14:30:00​	155​	13​
14:30:00​	152​	16​
14:30:00​	152​	16​
15:00:00​	168​	0​
15:00:00​	160​	8​
15:00:00​	156​	12​
15:00:00​	154​	14​
15:00:00​	153​	15​
15:00:00​	150​	18​
15:00:00​	149​	19​
15:00:00​	148​	20​
15:00:00​	143​	25​
15:10:00​	168​	0​
15:10:00​	166​	2​
15:10:00​	163​	5​
15:10:00​	163​	5​
15:10:00​	164​	4​
15:10:00​	149​	19​
15:10:00​	148​	20​
15:10:00​	143​	25​
15:10:00​	142​	26​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1
2	14:00:00	170	0
3	14:00:00	164	6
4	14:00:00	163	7
5	14:00:00	162	8
6	14:00:00	161	9
7	14:00:00	159	11
8	14:00:00	158	12
9	14:00:00	157	13
10	14:00:00	155	15
11	14:00:00	155	15
12	14:00:00	150	20
13	14:30:00	168	0
14	14:30:00	159	9
15	14:30:00	155	13
16	14:30:00	155	13
17	14:30:00	152	16
18	14:30:00	152	16
19	15:00:00	168	0
20	15:00:00	160	8
21	15:00:00	156	12
22	15:00:00	154	14
23	15:00:00	153	15
24	15:00:00	150	18
25	15:00:00	149	19
26	15:00:00	148	20
27	15:00:00	143	25
28	15:10:00	168	0
29	15:10:00	166	2
30	15:10:00	163	5
31	15:10:00	163	5
32	15:10:00	164	4
33	15:10:00	149	19
34	15:10:00	148	20
35	15:10:00	143	25
36	15:10:00	142	26
Data

Cell Formulas
Range	Formula
C2:C36	C2	=INDEX($B$2:$B$100,MATCH(A2,$A$2:$A$100,0))-B2

 

[Davebro]

Wow, that's brilliant, thanks so much for your help.

 

[Fluff]

You're welcome & thanks for the feedback.