U2=SUM(IF(FREQUENCY(IF($A$2:$A$45=$T2,MATCH($A$2:$A$45&$B$2:$B$45,$A$2:$A$45&$B$2:$B$45,0)),ROW($Q$2:$Q$45)-ROW($Q$2)+1),$Q$2:$Q$45))
Control+shift+enter
Evaluation sheet FREQUENCY.xlsxCopy down
Posts by CARACALLA
-
-
Re: MedianIF Array from a list
Hi
h4=MEDIAN(IF(A2:A22=G4,IF(E2:E22=E2,D2:D22))) control +shift+enter
Formatting h4 as h:mm