Posts by Sulavsingh6

    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.