2022-10-02 21:20
如图,B14公式:
=IF(B$12=$A14,0,ROW(B$12)-MAX(IF(B$2:B$12=$A14,ROW($2:$12))))
数组公式,按CTRL+SHIFT+回车,右拉,下拉