Thread: Find address
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RJW999 RJW999 is offline
external usenet poster
  
Posts: 1
Default Find address
I have a formula using a 3D range, =max(Oct:Sep!AB124). Is there anyway I can
return the address of the max value, which could be on any one of 12
worksheets? Formulae based on Address+Index don't work with a 3D range.
Reply With QuoteReply With Quote