How do I create a rating system?

What I want to do is create a rating system that has a running average, that updates every time I put a new rating in a designated cell.

For example, cell A2 would be my average rating, and A1 would be the designated rating cell for new entries.

So that I could enter a new number into A1, press return, and then A2 would be updated with the new average rating.

The A1 cell would then clear ready for a new entry.


Is this possible, if so, could anyone help with the solution?

It would be greatly appreciated.


Thanks,

Jeky.

You need to store the values somewhere. To do that

1) Copy the code below
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed - I used column Z to store the values

Then in cell A2, use the formula

=AVERAGE(Z:Z)

If you use a different column, change the Z:Z in the formula and the "Z" in the code.

Please Login or Register  to view this content.