Frequent occurance in two columns

  • Thread starter Thread starter ianripping
  • Start date Start date
I

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
 
Hi
not quite sure why small/alpha is the most frequent entry. Don't
understand your logic behind this :-)
 
Sorry, I meant big.

Dumb old me.

Is there a function for the most common occurance of text, not a numbe
which is mode
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top