software

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: www.excelforum.com/member.php...foamp;userid=9377
View this thread: www.excelforum.com/showthread...hreadid=493125Don't think so, minus 1 is the way.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jenniferlynnleequot;
lt;jenniferlynnlee.1zzs9m_1134500100.9988@excelfor um-nospam.comgt; wrote in
message news:jenniferlynnlee.1zzs9m_1134500100.9988@excelf orum-nospam.com...
gt;
gt; Will Excel allow a user to remove the header from the row count (it
gt; defaults as Row 1), so that a true count is rendered a list, such as a
gt; mailing database, rather than having to subtract 1 from the final
gt; tally?
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; jenniferlynnlee
gt; ------------------------------------------------------------------------
gt; jenniferlynnlee's Profile:
www.excelforum.com/member.php...foamp;userid=9377
gt; View this thread: www.excelforum.com/showthread...hreadid=493125
gt;
No, but if you create a dynamic range

cpearson.com/excel/named.htm#Dynamic

you can count only the items in the list.

In article
lt;jenniferlynnlee.1zzs9m_1134500100.9988@excelfor um-nospam.comgt;,
jenniferlynnlee
lt;jenniferlynnlee.1zzs9m_1134500100.9988@excelfor um-nospam.comgt; wrote:

gt; Will Excel allow a user to remove the header from the row count (it
gt; defaults as Row 1), so that a true count is rendered a list, such as a
gt; mailing database, rather than having to subtract 1 from the final
gt; tally?