Hi Guys,
I am using windows 10 and Excel 2010.
<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
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