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

Kingkoopa

Board Regular
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

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

oldbrewer

Well-known Member
 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

MrExcel MVP, Moderator
See if this is what you want.

Excel Workbook
ABCDEFG
1CUSTOMERCOUNTRYITEM CODESTARTEXPIREPRICEResult
2P01AUSAPPLE/A0126-Jan-1710-Jan-1875
3P01AUSAPPLE/A0111-Jan-1811-Jan-1975
4PALOMAVietnamAPPLE/A015-Sep-1730-Sep-1736
5PALOMAVietnamAPPLE/A014-Oct-1731-Dec-1742
6PALOMAVietnamAPPLE/A011-Jan-185-Jan-1842
7PALOMAVietnamAPPLE/A018-Jan-1814-Jan-1842
8PALOMAVietnamAPPLE/A0115-Jan-1831-Jan-1842Change
9BOO1AUSPEAR/A015-Sep-1730-Sep-1738
10BOO1AUSPEAR/A014-Oct-1731-Dec-1732
11BOO1AUSPEAR/A011-Jan-185-Jan-1843
12BOO1AUSPEAR/A018-Jan-1814-Jan-1845
13BOO1AUSPEAR/A0115-Jan-1831-Jan-1845Change
14HA01VietnamAPPLE/A019-Jun-1730-Jun-1735
15HA01VietnamAPPLE/A012-Jan-185-Jan-1823
16HA01VietnamAPPLE/A018-Jan-1814-Jan-1832
17HA01VietnamAPPLE/A0115-Jan-1831-Jan-1833Change
Changed

Kingkoopa

Board Regular
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

MrExcel MVP, Moderator
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.

1,181,607
Messages
5,930,884
Members
436,764
Latest member

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back