How do I count an E or e and be able to distinguish diff in ltrs?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple columns of letters that need to be counted each week.
Problem is that the codes are in upper or lower case letters and numbers. I
use countif to count everything then I have to double check the duplicates
such as E and e.

I've done research for several weeks and the results still do not work.
What do I need to do to make this calculation work without having to revisit
the columns?

Thanks for the help.

PS I'm using Excel 2003.
 
I have multiple columns of letters
multiple columns containing a *single* letter per cell? If so....

One approach: add a "helper" column for each column of letters. In those
columns, add this formula:
= CODE(cr)
(where c = column and r = row). The result will give you the ANSI value of
each letter. E and e will have different numerical values. Change your
COUNTIF formula range to refer to the Helper columns and use the ANSI
numerical values as the COUNTIF criteria (i.e., rather that "= E", use "=
69" for Upppercase E or "= 101" for Lowercase e).
 
Thank you so much. I'll test this tomorrow. I was wondering if there was a
way to convert the letters to numericals and then count the numericals.
 
Back
Top