Can the preset numbers in the column be changed?
 

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

"?B?c2hld2FoeWE=?=" wrote in
:

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)


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

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.


shewahya wrote:

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

--

Dave Peterson

Thanks so much!

"Dodo" wrote:

"?B?c2hld2FoeWE=?=" wrote in
:

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)


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)