Thread: How do I incorporate ref. range(like OFFSET() ) in a function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How do I incorporate ref. range(like OFFSET() ) in a function?
Maybe you mean something like:
http://contextures.com/xlNames01.html#Dynamic
(From Debra Dalgleish's site)

Vinod wrote:

I want to find out COUNTA() with a given reference range. But the reference
range should be changed automatically when I add/remove the cell

--

Dave Peterson
Reply With QuoteReply With Quote