Excel 查找筛选的列的分位数位置

参考自https://www.mrexcel.com/board/threads/quartile-of-filtered-list.163065/


=PERCENTILE(IF(SUBTOTAL(3,OFFSET(Q2:Q7345,ROW(Q2:Q7345)-ROW(Q2),,1)),Q2:Q7345),0.75)

=QUARTILE(IF(SUBTOTAL(3,OFFSET(Q2:Q7345,ROW(Q2:Q7345)-ROW(Q2),,1)),Q2:Q7345),3)

The formula you pick out must be confirmed with control+shift+enter, not just with enter.

 

 

posted @ 2022-07-03 20:49 

posted @ 2024-09-04 05:44  chinagod  阅读(7)  评论(0)  编辑  收藏  举报