Thread: reference first cell in a named range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert H Robert H is offline
external usenet poster
  
Posts: 113
Default reference first cell in a named range
Thats perfect, I knew it wasn't as hard as I was making it.
Thanks to you both

On Jan 14, 1:59 pm, "T. Valko" wrote:

=OFFSET(INDEX(dates,1),,COUNTA(dates))

--
Biff
Microsoft Excel MVP

Reply With QuoteReply With Quote