发布网友 发布时间:2022-05-21 15:47
共1个回答
热心网友 时间:2023-11-01 01:38
=SUM(IF($L$4:$L$8<=L4,"",1/(COUNTIF($L$4:$L$8,$L$4:$L$8))))+1追问数据在G2:G37,序号排在H2:H37,求大侠给个公式追答在h2单元格输入=SUM(IF($G$2:$G$37<=G2,"",1/(COUNTIF($G$2:$G$37,$G$2:$G$37))))+1,注意绝对引用,数组公式按shift+ctrl+enter启动运算。还注意数据单元格里必须都有数据。然后下拉H2单元格复制到H37.