Adding and then comparing multiple amounts

[tiger_78]

I need to achieve by Distinct Client, the following 2 Columns in Sheet 2:
"Total Per Client (the aggregation / addition of amounts)" and "Compare with Sheet 1 (difference comparison with the amount in Sheet 1)"
The amount and comparison needs to be on the Maximum Date line.
Thanks!

Sheet1

Unique Client No.	date	amount
246777	20/07/2020​	15.59
247051	21/07/2020​	42.50
247099	25/07/2020​	14.50
247174	01/07/2020​	41.00
249650	14/08/2020​	156.00

Sheet2

Duplicate Client No.	Date	amount	total per Client	compare with sheet 1
246777	20/07/2020​	15.00	15.00	0.59
247051	21/06/2020​	20.00
247051	21/07/2020​	20.00	40.00	2.50
247099	25/07/2020​	10.00	10.00	4.50
247174	01/05/2020​	13.00
247174	01/06/2020​	13.00
247174	01/07/2020​	13.00	36.00	5.00
249650	15/05/2020​	49.80
249650	15/06/2020​	49.80
249650	16/06/2020​	49.80	149.40	6.60

 

[tiger_78]

This is related to my previous post

Match Unique vs Duplicate Dates

Hi, I need a solution to this... I am comparing Sheet 1 Unique Dates, with Sheet 2 Duplicate Dates - both for the same Client. My aim is to test with a 'True' or 'False' flag 'field I want', if a date matches or not - for each Client: If any Date within a Client matches, Flag with TRUE (the...

www.mrexcel.com