Forum Discussion

djwebb's avatar
djwebb
Copper Contributor
Dec 16, 2018

naming a collum

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

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    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])

     

Resources