Hi! How do I create a price list where I want the most expensive item on top and the cheapest item in the bottom? I also want the items to be labeled with a number based on which order they are in the list. So the second most expensive item should be labeled with “2”. Also, the prices can be updated by me and when that happens I want the list to automatically change order and the items should get the correct label depending on where in the list they ended up.
You can use the sort option on your price column.
You can use a RANK function inside the sheet to do this for you. It will update automatically.
Thank you very much for the help!
If you have any problems implementing it, do let me know.