Thread: function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 168
Default 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