Formula to compare latest result vs the previous results. If difference state changed

[Kingkoopa]

Hi Guys,

I am using windows 10 and Excel 2010.

CUSTOMER	COUNTRY	ITEM CODE	START	EXPIRE	PRICE	Result
P01	AUS	APPLE/A01	26-Jan-17	10-Jan-18	75.00
P01	AUS	APPLE/A01	11-Jan-18	11-Jan-19	75.00
PALOMA	Vietnam	APPLE/A01	05-Sep-17	30-Sep-17	36.00
PALOMA	Vietnam	APPLE/A01	04-Oct-17	31-Dec-17	42.00
PALOMA	Vietnam	APPLE/A01	01-Jan-18	05-Jan-18	42.00
PALOMA	Vietnam	APPLE/A01	08-Jan-18	14-Jan-18	42.00
PALOMA	Vietnam	APPLE/A01	15-Jan-18	31-Jan-18	42.00	Changed
BOO1	AUS	PEAR/A01	05-Sep-17	30-Sep-17	38.00
BOO1	AUS	PEAR/A01	04-Oct-17	31-Dec-17	32.00
BOO1	AUS	PEAR/A01	01-Jan-18	05-Jan-18	43.00
BOO1	AUS	PEAR/A01	08-Jan-18	14-Jan-18	45.00
BOO1	AUS	PEAR/A01	15-Jan-18	31-Jan-18	45.00	Changed
HA01	Vietnam	APPLE/A01	09-Jun-17	30-Jun-17	35.00
HA01	Vietnam	APPLE/A01	02-Jan-18	05-Jan-18	23.00
HA01	Vietnam	APPLE/A01	08-Jan-18	14-Jan-18	32.00
HA01	Vietnam	APPLE/A01	15-Jan-18	31-Jan-18	33.00	Changed

<tbody>
</tbody>

I am looking for a formula that is able to compare the latest price vs the previous prices. If there is a change in price from the latest vs the previous (regardless of which date). The result column would show changed in the latest price.

Is this possible .

Thank you

 

[oldbrewer]

CUSTOMER	COUNTRY	ITEM CODE	START	EXPIRE	PRICE	Result
P01	AUS	APPLE/A01	26-Jan-17	10-Jan-18	75
P01	AUS	APPLE/A01	11-Jan-18	11-Jan-19	75
PALOMA	Vietnam	APPLE/A01	05-Sep-17	30-Sep-17	36
PALOMA	Vietnam	APPLE/A01	04-Oct-17	31-Dec-17	42
PALOMA	Vietnam	APPLE/A01	01-Jan-18	05-Jan-18	42
PALOMA	Vietnam	APPLE/A01	08-Jan-18	14-Jan-18	42
PALOMA	Vietnam	APPLE/A01	15-Jan-18	31-Jan-18	42	Changed	<<<<<<	this has not changed
BOO1	AUS	PEAR/A01	05-Sep-17	30-Sep-17	38			from the row above
BOO1	AUS	PEAR/A01	04-Oct-17	31-Dec-17	32
BOO1	AUS	PEAR/A01	01-Jan-18	05-Jan-18	43			are you asking if the latest price
BOO1	AUS	PEAR/A01	08-Jan-18	14-Jan-18	45			is different from the first price
BOO1	AUS	PEAR/A01	15-Jan-18	31-Jan-18	45	Changed		for paloma vietnam apple/a01
HA01	Vietnam	APPLE/A01	09-Jun-17	30-Jun-17	35			(ie 36 on 5 sept 2017 ?
HA01	Vietnam	APPLE/A01	02-Jan-18	05-Jan-18	23
HA01	Vietnam	APPLE/A01	08-Jan-18	14-Jan-18	32
HA01	Vietnam	APPLE/A01	15-Jan-18	31-Jan-18	33	Changed

<colgroup><col><col><col><col><col><col span="7"></colgroup><tbody>
</tbody>

 

[Peter_SSs]

See if this is what you want.

Excel Workbook
	A	B	C	D	E	F	G
1	CUSTOMER	COUNTRY	ITEM CODE	START	EXPIRE	PRICE	Result
2	P01	AUS	APPLE/A01	26-Jan-17	10-Jan-18	75
3	P01	AUS	APPLE/A01	11-Jan-18	11-Jan-19	75
4	PALOMA	Vietnam	APPLE/A01	5-Sep-17	30-Sep-17	36
5	PALOMA	Vietnam	APPLE/A01	4-Oct-17	31-Dec-17	42
6	PALOMA	Vietnam	APPLE/A01	1-Jan-18	5-Jan-18	42
7	PALOMA	Vietnam	APPLE/A01	8-Jan-18	14-Jan-18	42
8	PALOMA	Vietnam	APPLE/A01	15-Jan-18	31-Jan-18	42	Change
9	BOO1	AUS	PEAR/A01	5-Sep-17	30-Sep-17	38
10	BOO1	AUS	PEAR/A01	4-Oct-17	31-Dec-17	32
11	BOO1	AUS	PEAR/A01	1-Jan-18	5-Jan-18	43
12	BOO1	AUS	PEAR/A01	8-Jan-18	14-Jan-18	45
13	BOO1	AUS	PEAR/A01	15-Jan-18	31-Jan-18	45	Change
14	HA01	Vietnam	APPLE/A01	9-Jun-17	30-Jun-17	35
15	HA01	Vietnam	APPLE/A01	2-Jan-18	5-Jan-18	23
16	HA01	Vietnam	APPLE/A01	8-Jan-18	14-Jan-18	32
17	HA01	Vietnam	APPLE/A01	15-Jan-18	31-Jan-18	33	Change
Changed

 

[Kingkoopa]

Hi Oldbrewer,

The latest price will compare with each previous price. As long as there was a difference in the previous prices it will reflect as changed. Hence for paloma vietnam apple/a01 even though the previous price is the same at 42. But the first price is 36 so it should still reflect as changed.

Hi Peter_SSs,

It worked so far thanks so much :D

 

[Peter_SSs]

Hi Peter_SSs,

It worked so far thanks so much :D

You are welcome. If problems arise, post back with sample data and further explanation.