I am an excel noob and was hoping to get some advice. I want to make an excel file (I am using google sheets) to keep track of prices of groceries. I’d like to input all the prices of individual grocery items every time I go shopping.

• I want to be able to input multiple prices from different stores for each individual item

• For each item I want it to show the lowest, average, and highest price of the prices I have recorded for that item (per store)

• This is a bonus but it would be neat if it highlighted the lowest average price of all the stores

Here’s a bit of a mockup of what I’m picturing: https://i.imgur.com/5FiRLnl.png

If any of y’all have any advice that would be lovely. (Not only in how to write the formulas and setup the tables, but also if there is some good functionality I’m overlooking that would provide valuable insight into prices and how to shop better.)

Thanks!

In 2019 I made a price spreadsheet for the things we normally buy. I found it on my computer over the weekend so I thought I would do an updated price list and see the comparison.

Some items went up drastically, some stayed basically the same and a few were actually a little less. Obviously, the eggs were a huge increase, 18 eggs in 2019 were $1.57 and 18 yesterday were $10.99.

On the original spreadsheet I listed the item specifics - brand, amount/weight, so the comparison would be for the exact thing.

Overall the total for all the items in 2019 was $273.46. The total for all the items in 2025 was $386.77. That’s an increase of $130.30. The federal minimum wage has not increased in that time. So for people making $7.25 an hour, they are making no more pay, but possibly having an increase of $130.30 on a grocery run. This does not include any fresh beef, chicken or pork, which are way more expensive than they were then. I wish I had noted those prices as well, but they fluctuate so much that I didn’t bother.

Editing to add my location. US, southeast Missouri.

https://docs.google.com/spreadsheets/d/1bO8xQ2Z6vFqJ2m10cOQb2XKRzxSxzUz8iry673KgsaY/edit