Comment Response: Solving an Excel Query Using a Pivot Table

This is a response to a comment on one of my videos found here: https://youtu.be/h2RcY_B1vGo My solution to the query was to use a pivot table, as demonstrated in this video. I hope it helped!

The comment was:
"Hey Sally can you please me solve this query
The situation is there are 3-buy and 2-sell on the column:
buy
buy
buy 
sell
sell

i now want to calculate which is the word repeated max and by what no 
for this the ans is 
buy (3)"