多条件去除重复项计数

月份船名编号个数(0)(1)(2)(3)(4)(5)(6)

1广州100121广州100111TRUE1广州FALSE FALSE

1广州10021广州100222TRUE1广州FALSE FALSE

1深圳10031深圳100333TRUE1深圳TRUE TRUE

1深圳10041深圳100444TRUE1深圳TRUE TRUE

1深圳10041深圳100445FALSE1深圳TRUE FALSE

2深圳10052深圳100566TRUE2深圳FALSE FALSE

2深圳10062深圳100677TRUE2深圳FALSE FALSE

2深圳10072深圳100788TRUE2深圳FALSE FALSE

2陆丰10082陆丰100899TRUE2陆丰FALSE FALSE

2陆丰10082陆丰1008910FALSE2陆丰FALSE FALSE

(0)=$A$2:$A$11&$B$2:$B$11&$C$2:$C$11

(1)=MATCH($A$2:$A$11&$B$2:$B$11&$C$2:$C$11,$A$2:$A$11&$B$2:$B$11&$C$2:$C$11,0)

(2)=ROW($A$2:$A$11)-ROW($A$2)+1

(3)=(MATCH($A$2:$A$11&$B$2:$B$11&$C$2:$C$11,$A$2:$A$11&$B$2:$B$11&$C$2:$C$11,0)=ROW($A

(4)=$A$2:$A$11&$B$2:$B$11

(5)=($A$2:$A$11&$B$2:$B$11)="1深圳"

(6)=(MATCH($A$2:$A$11&$B$2:$B$11&$C$2:$C$11,$A$2:$A$11&$B$2:$B$11&$C$2:$C$11,0)=ROW($A

(7)=ROW($A$2:$A$11)

(8)=IF((MATCH($A$2:$A$11&$B$2:$B$11&$C$2:$C$11,$A$2:$A$11&$B$2:$B$11&$C$2:$C$11,0)=ROW

(7)(8)

2FALSE

3FALSE

44

55

6FALSE

7FALSE

8FALSE

9FALSE

10FALSE

11FALSE

$C$2:$C$11,0)

&$C$2:$C$11,0)=ROW($A$2:$A$11)-ROW($A$2)+1)

&$C$2:$C$11,0)=ROW($A$2:$A$11)-ROW($A$2)+1)*$A$2:$A$11&$B$2:$B$11="1深圳"

$11&$C$2:$C$11,0)=ROW($A$2:$A$11)-ROW($A$2)+1)*$A$2:$A$11&$B$2:$B$11="1深圳",ROW($A$2:$A$11))

$11))