Excel函数或VBA高手解决最后一次同方向连续出现答:=IF(OR(INDEX(F3:F12,COUNTIF(F3:F12,"<>"))={"正克","正生"}),"正向","反向")&MAX(FREQUENCY(IF(LEFT(F3:F12,1)=LEFT(INDEX(F3:F12,COUNTIF(F3:F12,"<>")),1),ROW($A$3:$A$12)),IF(LEFT(F3:F12,1)=LEFT(INDEX(F3:F12,COUNTIF(F3:F12,"<>")),1),,ROW($A$3...