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")
 
You must log in or register to reply here.

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

Similar Threads

Scrabble Value calculation for Welsh words 0
Adding up letter values 11
Indirect function and data validation dropdown box 2
Need formula to increase Alpha character to next letter 2
Complicated Formula 5
Trying to run excel vba code when cell value changes from empty to entered value. 1
Summing rows using formulas with variables 1
Excel VBA - Problem with Closing Print Preview 0

Back
Top