Tallying up 2 Alpha's

  • Thread starter Thread starter martialtiger
  • Start date Start date
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
 
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")
 
Back
Top