Excel Filtering/Pivot table

[Kate Jenkins]

In my spreadsheet column A lists the company names relating to  orders placed (names repeat), column B has contact names who have placed orders (names also repeat).  I need to identify the most frequent orderer. Can I do this via a pivot table? And if so, how?

[#2]

Hi Kate,

If you pivot your table adding company names in rows and count of orders in values you will see how many orders each company did.

Or you need only the name of most frequent orderer and nothing more?