View Single Post
  #2   Report Post  
Old November 9th 09, 05:16 AM posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default Find first empty cell in column

Check your previous post..

=SUMPRODUCT(MATCH(TRUE,A1:A100="",0))

If this post helps click Yes
---------------
Jacob Skaria


"TomHull" wrote:

hi,

Dos anyone know if there is a formula method for returning the cell
reference of the first cell in a column that is blank?

Cheers.