Thread: Using the results of the ADDRESS formula in another formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP JP is offline
external usenet poster
  
Posts: 103
Default Using the results of the ADDRESS formula in another formula
Using the ADDRESS formula, cell B1 evaluates to A10.
Using the ADDRESS formula, cell B2 evaluates to A20.
I am trying to enter the MAX formula in cell C1 that uses the addresses
contained in B1 and B2
so that you have, in effect,
=MAX(A10:A20)

Thank you in advance.
Reply With QuoteReply With Quote