Sorting, counting , listing help VBA

[vasiliskyj]

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.[TABLE="width: 300"]
<tbody>[TR]
[TD]COMLUM A[/TD]
[TD]COLUM B[/TD]
[/TR]
[TR]
[TD]Collision,Property Damage,Rental Reimbursement[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Collision,Property Damage,Rental Reimbursement[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Collision[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]collision [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]collision [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]comprehensive, collision [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]comprehensive collision [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.

 

[NeonRedSharpie]

Define "similar". What do your results look like?

 

[vasiliskyj]

Define "similar". What do your results look like?

Sorry not sure what you mean?