Thread: Dynamic Assignment of a Cell Address In Formula
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Dynamic Assignment of a Cell Address In Formula
Sorry for the confusion ...

=ADDRESS(SUMPRODUCT(MAX((ROW(J8:OFFSET(J8,COUNT(J8 :J965536),
0)))*(J8:OFFSET(J8,COUNT(J8:J965536),0)<=K6))),10, 4)

HTH

Reply With QuoteReply With Quote