COUNTIF 数を数える
| ID | Count | |
|---|---|---|
| abc001 | ||
| abc001 | ||
| abc002 | ||
| abc003 | ||
| abc003 | ||
| abc003 |
上記の Count を数えたい場合
=COUNTIF($A$2:A2,A2)
桁数を合わせたいなら
=TEXT(COUNTIF($A$2:A2,A2),"00")
| ID | Count | |
|---|---|---|
| abc001 | 01 | |
| abc001 | 02 | |
| abc002 | 01 | |
| abc003 | 01 | |
| abc003 | 02 | |
| abc003 | 03 | |
| abc005 | 01 | |
| abc005 | 02 | |
| abc005 | 03 | |
| abc005 | 04 | |
| abc005 | 05 | |
| abc005 | 06 | |
| abc005 | 07 | |
| abc005 | 08 |
