Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
"?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) |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
add only positive numbers and avg in a column | Excel Worksheet Functions | |||
Add selected numbers in a column that are a different color | Excel Discussion (Misc queries) |