Help

[Phill032]

Hi All, any help on this would be greatly appreciated.
The data below refers to a Used car stocklist advertising changes. Each line represents a log of a price change on the internet.
I need the following data retrieved from this list.
1 - Total number of internet changes for each car
2 - The Date of the last previous change
3 - The amount of the last previous change
4 - Total Price change variance

Stock#	Value Before	Value After	Log Date
1234	0	13,888	01/03/2019
1234	13,888	13,945	03/03/2019
1234	13,945	13,940	06/03/2019
1235	0	15,990	04/03/2019
1235	15,990	16,580	06/03/2019
1235	16,580	16,690	07/03/2019

<tbody>
</tbody>

 

[sandy666]

if 2007 so you should use formula solution from post#2

have a nice day

 

[RasGhul]

Change to this for the "Amount of Last" column

=SUMPRODUCT(($A$3:$A$8=A11)*($D$3:$D$8=C11)*$B$3:$B$8)

This returns
#1234 $13,945
#1235 $16,580