How to get the median ages of children attending different schools by schools?

[Badstep]

hello all,

I've been struggling with this formula for 2 days. I can calculate for one school by selecting the appropriate ranges, but my data has 7000 schools and several hundred thousand rows of data. There has to be an easier way.......

The data is aligned as follows:

School Age Frequency

School1 5 25 (means that school1 has 25 students that are 5 years old)



Can anyone help?

[Nisha Dhawan]

Hello Badsetp,

Welcome to the forum.

Instead of showing it on the bode, could you upload the attachment here for better understanding please?


Attach A File.jpg

[Badstep]

Student age Data by school 2.xlsx

Attached is a sample of the date