Thread: Find Nonblank Cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Find Nonblank Cell
="A"&MATCH(TRUE,A1:A10<"",0)

ctrl+shift+enter, not just enter


"Mike" wrote:

Is there a function that will find the first non blank cell in an array, like
returning cell address, or position in the array?
Reply With QuoteReply With Quote