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.

???

Advanced	Safety
Major	CD
Standard	PD
Advanced	Safety
Advanced	PD
Major	QC
Advanced	PD
Quick	QC
Advanced	Safety

<tbody>
</tbody><colgroup><col><col></colgroup>

 

[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....