Forum Discussion
Generate a report of price changes.
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.
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.
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.
I've used the Advanced Filter, but you can also use the standard Filter.
It's very easy!
