How can I recognize the first 2 letters in a cell using formulas? I want to
be able to recognize cells which contain certain initials from employees.
Example would be if C1=SS Glass, C2=AF Metal and C3=SS Paper, I need to know
that SS had 2 entries.

I am using Office 2003 w/ SP3.

Thanks,

Steve

You can use this:

=LEFT(C1,2)

to extract the first 2 characters of cell C1, and then copy it down.
In another cell you could have:

=COUNTIF(C:C,"SS")

to count the number of SS values.

Hope this helps.

Pete

On Mar 26, 11:01*am, Stevo wrote:
How can I recognize the first 2 letters in a cell using formulas? I want to
be able to recognize cells which contain certain initials from employees.
Example would be if C1=SS Glass, C2=AF Metal and C3=SS Paper, I need to know
that SS had 2 entries.

I am using Office 2003 w/ SP3.

Thanks,

Steve

Hi,

Try this

=SUM(IF(LEFT(C1:C20,2)="ss",1,0))

It's an array so commit with Ctrl+Shift+Enter

Mike

"Stevo" wrote:

How can I recognize the first 2 letters in a cell using formulas? I want to
be able to recognize cells which contain certain initials from employees.
Example would be if C1=SS Glass, C2=AF Metal and C3=SS Paper, I need to know
that SS had 2 entries.

I am using Office 2003 w/ SP3.

Thanks,

Steve

On Wed, 26 Mar 2008 04:01:01 -0700, Stevo
wrote:

How can I recognize the first 2 letters in a cell using formulas? I want to
be able to recognize cells which contain certain initials from employees.
Example would be if C1=SS Glass, C2=AF Metal and C3=SS Paper, I need to know
that SS had 2 entries.

I am using Office 2003 w/ SP3.

Thanks,

Steve


=COUNTIF(C1:C3,"SS *")

or, with some initials in D1

=COUNTIF(C1:C3,D1 & " *")
--ron