Can the preset numbers in the column be changed?

[Guest]

I am trying to do a sign in sheet and would like horizontally at the top
name, address etc, and name is in A1, address is in B1 etc. for example. Is
there a way to make it so the numbering will reflect how many people sign in
without adding a column with numbering? Thanks in advance. Teresa

 

[Dodo]

I am trying to do a sign in sheet and would like horizontally at the
top name, address etc, and name is in A1, address is in B1 etc. for
example. Is there a way to make it so the numbering will reflect how
many people sign in without adding a column with numbering? Thanks in
advance. Teresa

You can add a formula in a cell to count non-empty cells:

=counta(range)

where range are the cells where the names are entered or the attendance is
marked, e.g. =counta(a2:a328)

 

[Dave Peterson]

Nope.

But you could put your data in column B to whatever and use a formula like this:

In A3:
=if(b3="","",a2+1)
drag down for a few (lots of) rows.

And put 1 in A2 (and headers in row 1)


Then select your range A:whatever.
Data|filter|autofilter

Filter by non-blanks in column A when you want to print.

Data|Filter|Show all
when you want to see everything.

 

[Guest]

Thanks so much!

You can add a formula in a cell to count non-empty cells:

=counta(range)

where range are the cells where the names are entered or the attendance is
marked, e.g. =counta(a2:a328)