View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excel12345
 
Posts: n/a
Default How can I use numbers to define range for Max() ?


I know the absolute offsets of the rows and columns in a seperate sheet
and want to get the max of that range. For example:
=Max(CC, RR, cc, rr)

where all the parameters are numbers allowing me to define the range.


--
excel12345
------------------------------------------------------------------------
excel12345's Profile: http://www.excelforum.com/member.php...o&userid=31975
View this thread: http://www.excelforum.com/showthread...hreadid=517016