Counting names in a column

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

I have entered a list of names in Column A. How can I count the number
of names I have entered and have that number appear in cell B1. I will
be entering a varying number of names each time I open and use this
worksheet. Thanks for the help.
 
hi, im quite new myself.
Clik on cell B1
Choose set in function COUNTA(A:A)

regards jan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a formula to a range 2
Count occurrences of filename in column 5
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
VBA CreateNames (ignores last 5 rows?) 6
Excel VBA - counting cells by colors and names to it in two different rows. 0
How do I count the number of times a particular word is used? 2
Counting Criteria Values with For Loop 3
Optional argument as Variant not acting like number 4

Back
Top