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

"=?Utf-8?B?c2hld2FoeWE=?=" <[email protected]> wrote in
news:[email protected]:

> 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:

> "=?Utf-8?B?c2hld2FoeWE=?=" <[email protected]> wrote in
> news:[email protected]:
>
> > 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)
>