Hi all,
I am looking for a VBA code to list the averages of a set of data based on criteria in a different column. The easiest way for me to explain this is to just show what I mean! The data set will be changing based on a Query result, so it can't be fixed to specific cells.
Example data:
Criteria Data
1 9
1 3
1 2
1 7
2 8
2 6
2 8
4 3
4 4
4 6
4 7
4 6
4 4
5 2
5 1
6 6
6 5
6 7
6 8
Example desired output:
Criteria Average
1 5.25
2 7.33
4 5
5 1.5
6 6.5
Any help would be greatly appreciated!
Thanks,
Jamie
Bookmarks