由於題意有歧義，按以下三種方式理解，公式分別為：
1、A7與A2：A6之間的數字有重復，B7顯示“AAA”，否則顯示“B”
＝IF(COUNTIF(A2:A7,A7)>1,"AAA","B")
2、A7與A3：A6之間的數字有重復，B7顯示“AAA”，否則顯示“B”
＝IF(COUNTIF(A3:A7,A7)>1,"AAA","B")
3、A3：A7中的連續五個數字有重復，B7顯示“AAA”，否則顯示“B”
＝IF(COUNTIF(A3:A7,A7)>1,"AAA",IF(COUNTIF(A3:A7,A6)>1,"AAA",IF(COUNTIF(A3:A7,A5)>1,"AAA",IF(COUNTIF(A3:A7,A4)>1,"AAA",IF(COUNTIF(A3:A7,A3)>1,"AAA","B")))))
如不明白，可再追問。或郵箱308851504@qq.com交流