Automate Price check by date - Data Dump analysis based on 3 columns

  • Hi,

    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!