View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default counting column elements

Hi Daniel
with the assumption that where are no blank rows in between use
=COUNTA($A:$A)
HTH
Frank

Daniel Pena wrote:
I just imported a text file into Excel. I want to be able to count
up the number of elements in Column A1 so I can get an exact count to
set up an Array. Can anyone help? Really appreciate the help. Thanks
in advance.