Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't count header as Row 1?
Will Excel allow a user to remove the header from the row count (it defaults as Row 1), so that a true count is rendered a list, such as a mailing database, rather than having to subtract 1 from the final tally? Thanks! -- jenniferlynnlee ------------------------------------------------------------------------ jenniferlynnlee's Profile: http://www.excelforum.com/member.php...fo&userid=9377 View this thread: http://www.excelforum.com/showthread...hreadid=493125 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't count header as Row 1?
Don't think so, minus 1 is the way.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "jenniferlynnlee" <jenniferlynnlee.1zzs9m_1134500100.9988@excelfor um-nospam.com wrote in message news:jenniferlynnlee.1zzs9m_1134500100.9988@excelf orum-nospam.com... Will Excel allow a user to remove the header from the row count (it defaults as Row 1), so that a true count is rendered a list, such as a mailing database, rather than having to subtract 1 from the final tally? Thanks! -- jenniferlynnlee ------------------------------------------------------------------------ jenniferlynnlee's Profile: http://www.excelforum.com/member.php...fo&userid=9377 View this thread: http://www.excelforum.com/showthread...hreadid=493125 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't count header as Row 1?
No, but if you create a dynamic range
http://cpearson.com/excel/named.htm#Dynamic you can count only the items in the list. In article <jenniferlynnlee.1zzs9m_1134500100.9988@excelfor um-nospam.com, jenniferlynnlee <jenniferlynnlee.1zzs9m_1134500100.9988@excelfor um-nospam.com wrote: Will Excel allow a user to remove the header from the row count (it defaults as Row 1), so that a true count is rendered a list, such as a mailing database, rather than having to subtract 1 from the final tally? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep blank pages from being included in header count? | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |