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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SharonR - 25 Aug 2005 21:27 GMT

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.

Reply to this Message

George Nicholson - 26 Aug 2005 22:08 GMT

>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).

Signature

George Nicholson

Remove 'Junk' from return address.

>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.
[quoted text clipped - 10 lines]
>
> PS I'm using Excel 2003.

Reply to this Message

SharonR - 27 Aug 2005 01:05 GMT

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.

> >I have multiple columns of letters
> multiple columns containing a *single* letter per cell? If so....
[quoted text clipped - 22 lines]
> >
> > PS I'm using Excel 2003.

Reply to this Message