Home > Mobile >  Excel - Compute the median by date and sector
Excel - Compute the median by date and sector

Time:01-25

I am glad to write my first post here :)

I have a question: using excel, I need to compute the media for Date and Sector, as we can see from this short example that I have created:

enter image description here

If you do not have Excel 365, you can use

= MEDIAN(AGGREGATE(14,6, 1/((Table1[Date]=G4)*(Table1[Sector]=H4))*Table1[Value],ROW(INDEX($A:$A,1):INDEX($A:$A,SUMPRODUCT((Table1[Date]=G4)*(Table1[Sector]=H4))))))
  •  Tags:  
  • Related