function
 

Can someone help me? I want a function that will do the following:
When text is entered into a cell in column B, lookup that text in column A
and then count the number of ocurrences in column A, putting the results in
column C.

Thanks in advance,
rob

function
 

=COUNTIF(A:A,B1)


"rob" wrote in message
...
Can someone help me? I want a function that will do the following:
When text is entered into a cell in column B, lookup that text in column A
and then count the number of ocurrences in column A, putting the results
in
column C.

Thanks in advance,
rob

function
 

In C1 (for example)

=COUNTIF(A1:A100,B1)

HTH

"rob" wrote:

Can someone help me? I want a function that will do the following:
When text is entered into a cell in column B, lookup that text in column A
and then count the number of ocurrences in column A, putting the results in
column C.

Thanks in advance,
rob