I am trying to build a spreadsheet that will help me track my ordered supplies for a large warehouse. I would like to be able to sort the information that I have by the frequency of purchase. i.e., If I ordered 1000 filters once, but 2 pipes one hundred times, I need to have the pipes higher ranked.
The information I have from our system is:
- name of product
- date ordered
- number used(on that specific date)
- cost
How do I build the sheet so that it tracks and sorts for me?
Bookmarks