- 最後登錄
- 2024-11-2
- 在線時間
- 682 小時
- 註冊時間
- 2007-8-19
- 閱讀權限
- 30
- 精華
- 0
- UID
- 2133047
- 帖子
- 1356
- 積分
- 1380 點
- 潛水值
- 22843 米
| 若瀏覽伊莉的時侯發生問題或不正常情況,請使用Internet Explorer(I.E)。 本帖最後由 星羽神話 於 2018-10-4 09:12 PM 編輯
想請教各位大神,
目前我想用countifs推測G2欄位,料號910G、不淨數>=1且批號不可重複的次數為何?
目前小弟只能寫出=countifs($ B : $ B,$A$2,$ D : $ D,">=1")
批號不可重複的計次,我就不知道如何處理了
懇請神人解答
| A | B | C | D | E | F | G | 1 | 料號別 | 料號 | 批號 | 不淨數 |
|
|
| 2
| 910G | 910G | 2A7C47 | 1 |
|
| 24 | 3 | 910F | 910G | 2A7C35 | 5 |
|
|
| 4
| 521G | 910G | 2A7C38 | 2 |
|
|
| 5
| | 910G | 2A7C38 | 2 |
|
|
| 6
| | 910G | 2A7C48 | 3 |
|
|
| 7
| | 910G | 2A7C57 | 1 |
|
|
| 8
| | 910G | 2A7C48 | 2 |
|
|
| 9
| | 910G | 2A7C48 | 1 |
|
|
| 10
| | 910G | 2A7C59 | 1 |
|
|
| 11
| | 910G | 2A7C57 | 10 |
|
|
| 12
| | 910G | 2A7C57 | 2 |
|
|
| 13
| | 910G | 2A7C57 | 1 |
|
|
| 14
| | 910G | 2A7C57 | 2 |
|
|
| 15
| | 910G | 2A7C57 | 1 |
|
|
| 16
| | 910G | 2A7C59 | 25 |
|
|
| 17
| | 910G | 3A7CA5 | 6 |
|
|
| 18
| | 910G | 2A7C59 | 2 |
|
|
| 19
| | 910G | 2A7C47 | 4 |
|
|
| 20
| | 910G | 2A7C48 | 2 |
|
|
| 21
| | 910G | 2A7C33 | 1 |
|
|
| 22
| | 910F | 2A7C52 | 1 |
|
|
| 23
| | 910G | 2A8102 | 2 |
|
|
| 24
| | 910G | 2A8105 | 10 |
|
|
| 25
| | 910G | 2A8105 | 2 |
|
|
| 26
| | 910F | 2A8119 | 10 |
|
|
| 27
| | 521G | 2A8109 | 2 |
|
|
| 28
| | 910G | 2A8124 | 1 |
|
|
| 29
| | 910F | 2A8119 | 13 |
|
|
| 30
| | 910F | 2A8119 | 20 |
|
|
| 31
| | 910F | 2A8119 | 1 |
|
|
| 32
| | 910F | 2A8119 | 3 |
|
|
| 33
| | 910F | 2A8119 | 16 |
|
|
| ... |
|