View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default How to: Find first empty cell in column

It's this part

A1:A10=""

it's what is called an array formula, you can lookup array formula in help

http://www.cpearson.com/excel/ArrayFormulas.aspx


--


Regards,


Peo Sjoblom



"DW" wrote in message
...
Thanks everyone....

Now, this might be a dumb question, but why the ctrl+shift + enter combo
to commit the formula?


Don