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

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies