Help counting how many matches

[TSing3]

I have 2 columns of data. I need to count how many Advanced are also Safety and so on and so forth. How many Major are Safety, CD, etc. How many Advanced are Safety, CD, etc.

???
[TABLE="width: 136"]
<tbody>[TR]
[TD]Advanced[/TD]
[TD]Safety[/TD]
[/TR]
[TR]
[TD]Major[/TD]
[TD]CD[/TD]
[/TR]
[TR]
[TD]Standard[/TD]
[TD]PD[/TD]
[/TR]
[TR]
[TD]Advanced[/TD]
[TD]Safety[/TD]
[/TR]
[TR]
[TD]Advanced[/TD]
[TD]PD[/TD]
[/TR]
[TR]
[TD]Major[/TD]
[TD]QC[/TD]
[/TR]
[TR]
[TD]Advanced[/TD]
[TD]PD[/TD]
[/TR]
[TR]
[TD]Quick[/TD]
[TD]QC[/TD]
[/TR]
[TR]
[TD]Advanced[/TD]
[TD]Safety[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[wideboydixon]

https://support.office.com/en-us/ar...pId=xlmain11.chm60529&ui=en-US&rs=en-US&ad=US

 

[admiral100]

Hi,

I think a pivot table will do the job....