calculate the most common text values by groups

[alaas]

Hello!

I want to calculate the most common text value for groups. I have a table with a lot of records like an example below.

ID Code
1 HB
1 KU
1 KS
1 LV
1 KS
2 LM
2 KS
2 KS
2 LV
2 KS
3 KS
3 KS
3 KS
3 KS
3 KU
3 KS
3 LM
3 LV
3 KS

I want a table like below:
ID Code
1 KU
2 KS
3 KS

How can I do it in Excel 2010?

Thank you in advance.
Anne

 

[alaas]

Yes there is

This may help make it clearer:

Excel Pivot Table Filters - Top 10

Now I understood. I looked for the value filter from the pivot table vizard (row labels), not from the table. Now it works! Thank you very much.
Anne