View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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?