I am posting here for the first time; I need help automating a process in excel.
- Our data dump includes 3 columns (date, name, price).
- First I need to organize all the items bought by date (today's date)
- Then I need to check each items price (so the price associated with a name)
- Then I need to check the last time we purchased that item (1 week ago, 1 moth ago, 1 year ago, etc) and check the price we bought it for then vs. the price now
- We have a large list of items we purchase
- So Automating this would be helpful
- Currently it is a manual process
Any help would be really appreciated.