Tallying up 2 Alpha's

M

martialtiger

Say I have only 2 values I enter in a particular column. 1 is th
letter A, 2nd is the letter B. What I am looking to do is use
forumla that will determine whether there are more A's or B's in th
column and then have that Letter as the cell Value. (i.e. from A1:A1
there are 4 A's, 6 B's... therefore in my cell with this formula I wan
"B" as the value in it.) Hope this makes sense
 
K

Ken Wright

You didn't say what happens if both have the same - I've assumed A gets it:-

=IF(COUNTIF($A$1:$A$10,"A")>=COUNTIF($A$1:$A$10,"B"),"A","B")
 
Top