VBA: Count the number of times a value appears in a column
I am looking for help in VBA to achieve this. Some rows may have missing data in input sheet.
I am looking for help in VBA to achieve this. Some rows may have missing data in input sheet.
| abc.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | ID | Count number of times a value appears | ||
| 2 | ID1 | apple, bananna,apple | ||
| 3 | ID2 | Orange, Apple | ||
| 4 | ID3 | Grapes, grapes | ||
| 5 | ID4@#$% apple ^&*()_ | bananna | ||
| 6 | ID5 | apple | ||
| 7 | ID6 | orange, Apple, orange | ||
Input1 | ||||
| abc.xlsm | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Item | Total Item count | ID | ||
| 2 | Apple | 2 | ID2 | ||
| 3 | apple | 4 | ID1, ID5 | ||
| 4 | bananna | 2 | ID1, ID4!@#$% apple ^&*()_ | ||
| 5 | Orange | 1 | ID2 | ||
| 6 | orange | 2 | ID6 | ||
| 7 | grapes | 1 | ID3 | ||
Output1 | |||||
| abc.xlsm | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Item | Total Item count | ID | ||
| 2 | Apple | 6 | ID2, ID1, ID5 | ||
| 3 | bananna | 2 | ID1, ID4!@#$% apple ^&*()_ | ||
| 4 | Orange | 3 | ID2, ID6 | ||
| 5 | grapes | 1 | ID3 | ||
Output2 | |||||
