å¦å¾:å äºä¸¤ä¸ªè¾ å©åBåD
B1=COUNTIF(A$1:$A1,">0")+IF($A1<0,10^3,0)
å°äº0çéé¢å计C1=SUM(OFFSET($A$1,MATCH(MAX(COUNTIF($B$1:$B$20,$B$1:$B$20)),COUNTIF($B$1:$B$20,$B$1:$B$20),0)-1,,MAX(COUNTIF($B$1:$B$20,$B$1:$B$20))))
å°äº0ç次æ°C2=MAX(COUNTIF($B$1:$B$20,$B$1:$B$20))
DåEæ¯å¤§äº0ç
D1=COUNTIF($A$1:A1,"<0")+IF($A1>0,10^3,0)
E1=SUM(OFFSET($A$1,MATCH(MAX(COUNTIF($D$1:$D$20,$D$1:$D$20)),COUNTIF($D$1:$D$20,$D$1:$D$20),0)-1,,MAX(COUNTIF($D$1:$D$20,$D$1:$D$20))))
E2=MAX(COUNTIF($D$1:$D$20,$D$1:$D$20))
纯粹æ¯åæ°äº,ççè¡ä¸ã