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

Kingkoopa

Board Regular
Joined
Aug 7, 2014
Messages
94
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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,005
CUSTOMERCOUNTRYITEM CODESTARTEXPIREPRICEResult
P01AUSAPPLE/A0126-Jan-1710-Jan-1875
P01AUSAPPLE/A0111-Jan-1811-Jan-1975
PALOMAVietnamAPPLE/A0105-Sep-1730-Sep-1736
PALOMAVietnamAPPLE/A0104-Oct-1731-Dec-1742
PALOMAVietnamAPPLE/A0101-Jan-1805-Jan-1842
PALOMAVietnamAPPLE/A0108-Jan-1814-Jan-1842
PALOMAVietnamAPPLE/A0115-Jan-1831-Jan-1842Changed<<<<<<this has not changed
BOO1AUSPEAR/A0105-Sep-1730-Sep-1738 from the row above
BOO1AUSPEAR/A0104-Oct-1731-Dec-1732
BOO1AUSPEAR/A0101-Jan-1805-Jan-1843 are you asking if the latest price
BOO1AUSPEAR/A0108-Jan-1814-Jan-1845 is different from the first price
BOO1AUSPEAR/A0115-Jan-1831-Jan-1845Changedfor paloma vietnam apple/a01
HA01VietnamAPPLE/A0109-Jun-1730-Jun-1735 (ie 36 on 5 sept 2017 ?
HA01VietnamAPPLE/A0102-Jan-1805-Jan-1823
HA01VietnamAPPLE/A0108-Jan-1814-Jan-1832
HA01VietnamAPPLE/A0115-Jan-1831-Jan-1833Changed

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

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
51,858
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Aug 7, 2014
Messages
94
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
 

Forum statistics

Threads
1,148,294
Messages
5,745,944
Members
423,985
Latest member
sayed manzar

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top