BETA - Formula question

  • Thread starter Thread starter sarah.sehmbi
  • Start date Start date
S

sarah.sehmbi

I have a huge spreadsheet with names of people by last
name,first name in columns by month for the last 3 years.
I want to know how many times over the last year a person
has been entered. Eg. Smith, Joe - how many times his name
is entered without manually counting. Can you help me on
this puzzling question.

thank you Sarah
 
Assume your list was in column A1:A100, try this

=COUNTIF(A1:A100,B1)

and type whatever text string you want to count in cell B1.......

But remember, in a text-search thingy like this, the entrys have to always
be typed exactly the same every time......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top