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.
3 Replies
Mario,
Step 1
Create a new field beside the Price field and call it: (New Price).
Step 2
In the New Price field use https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 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 https://support.office.com/en-us/article/Video-Advanced-filter-details-BBD0CB0A-8F90-43DF-BF77-6AD3774DC420, but you can also use the standard https://support.office.com/en-us/article/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e.
It's very easy!
