Hi
I have a table that I would like to extract the average and median age groups, the table appears as follows
Age Total
0-10 5
11-20 10
21-30 8
31-40 15
and so on.....
I would like a formula that tells me which age group is the average eg 21-30 and which is the median eg 31-40, if possible
Thanks
Bookmarks