Return most common text string for a certain outcode

[alexgimson]

Hey guys (new to this forum)

I'm analysing UK restaurants by out-code. I want to see what the most popular type of restaurant is in a certain out-code. My table looks like this:

AB10 1BA British
AB10 1JG Mexican
AB10 1JR Indian
AB10 1JR Kebab
AB10 1SB Indian
AB10 1SQ Kebab
AB10 1TE Sushi
AB10 1TX Thai
AB10 1TX Kebab
AB10 6BR Italian
AB10 6BS Indian
AB10 6DA Chinese
AB10 6DB Italian
AB10 6NN Italian
AB10 6QD Indian
AB10 7AP Indian
AB10 7LH Chinese
AB11 5BL Hungarian
AB11 5NX Fish & Chips
AB11 6BB Indian
AB11 6BT Indian

Outcode in column A, next bit of postcode in column B and the food type in column C

I would like Excel to return the most common Food type for the out-code AB10, AB11 and so on...

I've tried using Index Match but to no avail so far

Any help would be greatly appreciated!

[Special-K]

Pivot table probably best

COUNT column C by column A

[oeldere]

With a pivot table.

[alexgimson]

Thanks guys!

I always try formulas. Sometime the simple ways are the best ways.

[oeldere]

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.