View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Count number of text rows???

Hi,

Am Mon, 3 Sep 2012 20:05:05 -0400 schrieb LAS:

Example

First Name Last Name
Alma Diderot
Mark Woolser
Amy Fleisher
Count 3


try:
=COUNTA(A:A)-1
-1 for the header


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2