求大神帮我E列用函数统计C列相同数值，如图效果，谢谢！！！

更新时间2020-01-08 05:44:20

=IF(C1="","",1)

=IF(C2="","",IF(INDEX(C:C,MAX(ISNUMBER($C$1:C1)*ROW($C$1:C1)))=C2,

                        INDEX(E:E,MAX(ISNUMBER($C$1:C1)*ROW($C$1:C1)))+1,1))

相关标签:谢谢，大神