Tying myself up in knots

[Beau the dog]

Hi,

I know this will be easy for you excel wizards, I'm tying myself up in knots.

We have a log, when I enter a new entry, I'd like the formula in the end column, to look for the last entry for that registration, and get the difference between the two ODO readings. The column header 'DATE' is in cell B6, there are no merged cells. Using latest version of excel.

Please and thank you!

DATE	REGISTRATION	ODO	Adblue drawn (ltr)	Depot / OC	Driver	Odometer difference
11-Apr-24	GHY	1254	20	London	Homer simpson
11-May-24	GHY	1578	30	London	Homer simpson
11-Apr-24	YTR	2056	80	Liverpool	Ned Flanders
11-May-24	YTR	3452	20	Liverpool	Ned Flanders
11-Jul-24	GHY	2136	30	London	Homer simpson
11-Jul-24	YTR	4000	60	Liverpool	Ned Flanders

 

[Fluff]

If your dates will always be in order for each reg, how about

Fluff.xlsm
	A	B	C	D	E	F	G
1	DATE	REGISTRATION	ODO	Adblue drawn (ltr)	Depot / OC	Driver	Odometer difference
2	11-Apr-24	GHY	1254	20	London	Homer simpson	0
3	11-May-24	GHY	1578	30	London	Homer simpson	324
4	11-Apr-24	YTR	2056	80	Liverpool	Ned Flanders	0
5	11-May-24	YTR	3452	20	Liverpool	Ned Flanders	1396
6	11-Jul-24	GHY	2136	30	London	Homer simpson	558
7	11-Jul-24	YTR	4000	60	Liverpool	Ned Flanders	548
Sheet5

Cell Formulas
Range	Formula
G2:G7	G2	=C2-XLOOKUP(B2,B$1:B1,C$1:C1,C2,,-1)

 

[Beau the dog]

If your dates will always be in order for each reg, how about

Fluff.xlsm
	A	B	C	D	E	F	G
1	DATE	REGISTRATION	ODO	Adblue drawn (ltr)	Depot / OC	Driver	Odometer difference
2	11-Apr-24	GHY	1254	20	London	Homer simpson	0
3	11-May-24	GHY	1578	30	London	Homer simpson	324
4	11-Apr-24	YTR	2056	80	Liverpool	Ned Flanders	0
5	11-May-24	YTR	3452	20	Liverpool	Ned Flanders	1396
6	11-Jul-24	GHY	2136	30	London	Homer simpson	558
7	11-Jul-24	YTR	4000	60	Liverpool	Ned Flanders	548
Sheet5

Cell Formulas
Range	Formula
G2:G7	G2	=C2-XLOOKUP(B2,B$1:B1,C$1:C1,C2,,-1)

They should be in date, it will only be human error if not, and that's a 'me' problem!

Thank you as always.

 

[Fluff]

You're welcome & thanks for the feedback.