Forum Discussion
MEDIAN from aggregative data
Is there a way to find the median from aggregated data? For example, people were asked to rank something 1-5: 90x people ranked it 5 56x people ranked it 4 75x people ranked it 3 etc... H...
Maybe this:
=LET(ratings,TEXTJOIN(,,REPT(E1:I1,E2:I2)),pts,MID(ratings,SEQUENCE(LEN(ratings)),1)*1,MEDIAN(pts))