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

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

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?