Home

naming a collum

djwebb
Occasional Visitor

Hi

Im wondering if someone can help, im creating a table of a list of names both first and last names and I need to keep a count of how many people there are. Is there a way of renaming the column so that I can use the numbers down the side. EG. Column A rather than being A I could call it first name something like below

 

     A    B     C    D

1

2

3

4

5

 

could become

 

     First name    Last name

1

2

3

4

 

1 Reply

Hi,

 

what is the connection between counting entries and the column header?

 

Counting is simply:

=COUNTA(A:A)

or when formatted as a table:

=COUNTA(Table1[First name])