Frequent occurance in two columns

[ianripping]

I have these columns:

Column A

big
big
big
small
small
medium
bid
small

Column B

alpha
alpha
beta
beta
beta
alpha
alpha
beta

I want a forumla that will look at the two columns and report that th
row with small and alpha is the most frequent.

Any idea's

 

[Frank Kabel]

Hi
not quite sure why small/alpha is the most frequent entry. Don't
understand your logic behind this

 

[ianripping]

Sorry, I meant big.

Dumb old me.

Is there a function for the most common occurance of text, not a numbe
which is mode

 

[Frank Kabel]

Hi
try the following
1. Create a helper column c which combines column A + B. e.g. with the
formula
=A1&B1

2. Now use the following formula:
=INDEX(C1:C10,MATCH(MAX(COUNTIF(C1:C10,C1:C10)),COUNTIF(C1:C10,c1:C10),
0))

 

[ianripping]

Thanks Fran, works a treat, but how

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/lists.htm#MostCommon