vasiliskyj
New Member
- Joined
- Mar 26, 2014
- Messages
- 12
I have a list in excel in column B , I have over 20,000 cells which I would like to count similar cells. here is an example of my list.
<tbody>
</tbody>
I would like to count the entire colum B and count all the different types of coverage's listed and how many of them. Its a large list and accuracy is impartaint, thank you to whomever can help. VBA Macros is fine as well thanks.
| COMLUM A | COLUM B |
| Collision,Property Damage,Rental Reimbursement | |
| Collision,Property Damage,Rental Reimbursement | |
| Collision | |
| collision | |
| collision | |
| comprehensive, collision | |
| comprehensive collision |
<tbody>
</tbody>
I would like to count the entire colum B and count all the different types of coverage's listed and how many of them. Its a large list and accuracy is impartaint, thank you to whomever can help. VBA Macros is fine as well thanks.
