Generate a report of price changes.

[Mario Agosto]

Hello I have a very simple table with two fields an item number field and a price field. There are about 300 items. I get a price list every month, I would like to generate a report of only the items that have changed price. I get the price updates in a CVS file. Any help would be highly appreciated. 

[#2]

Mario,

Step 1

Create a new field beside the Price field and call it: (New Price).

Step 2

In the New Price field use VLOOKUP function to look into the price updates table and return the price update for each item.

Step 3

Create a new field beside the New Price and call it: (Change).

Step 4

In the Change field compare between the old price and the new price using the equality operator ( = ) to return a TRUE or a FALSE result.

Step 4

Filter the FALSE rows and create a new report from them.

   

[#3]

Thank You so much for your help Haytham. I downloaded the files and was able to make them work, to the point the prices got updated. Now I just need to figure out how to filter them. 

[#4]

I've used the Advanced Filter, but you can also use the standard Filter.

It's very easy!