I have a table of data (5000+ rows) with two columns, ID and value.
It may look like this:
ID Value
01 02
01 03
01 17
02 05
03 06
03 28
What I want to do is find the average value for each ID. i.e. =AVERAGE(rows where id=1)
How can I go about this?