Finding max from different ranges of data
 

Hello all (first post so bear with me)

I am currently working on an excel sheet which contains lots of data,
it lists a value for every hour of a whole year. What i cant seem to
get excel to do is find the maximum value in say a 24 hour period (this
must be a preiod that can be specified by me elsewhere in the sheet) and
get it to display the maximum value as i change the day for which i need
the data, as this will go on to be used elsewhere in the sheet. i hope i
am managing to explain this clearly :confused:

I think i may have to move into macro's to do this but have no
knowledge of them so if possible would like to continue to use
functions with which i am more familiar.

The problem keeps coming back to the fact that i can't tell excel to
find a set of data depending on another value, eg it wants
"=MAX(V10:V34)" but i want it to interpret "=MAX(V(10+B3):V(10+B4))"

if anyone knows anything that may help me with this is would be very
very greatful

thanks in advance

Owen


--
owen080808
------------------------------------------------------------------------
owen080808's Profile: http://www.excelforum.com/member.php...o&userid=32984
View this thread: http://www.excelforum.com/showthread...hreadid=528109

Finding max from different ranges of data
 

Hi

Try something like this:
=MAX(INDIRECT("V"&B3+10):INDIRECT("V"&B4+10))

Andy.

"owen080808" wrote
in message ...

Hello all (first post so bear with me)

I am currently working on an excel sheet which contains lots of data,
it lists a value for every hour of a whole year. What i cant seem to
get excel to do is find the maximum value in say a 24 hour period (this
must be a preiod that can be specified by me elsewhere in the sheet) and
get it to display the maximum value as i change the day for which i need
the data, as this will go on to be used elsewhere in the sheet. i hope i
am managing to explain this clearly :confused:

I think i may have to move into macro's to do this but have no
knowledge of them so if possible would like to continue to use
functions with which i am more familiar.

The problem keeps coming back to the fact that i can't tell excel to
find a set of data depending on another value, eg it wants
"=MAX(V10:V34)" but i want it to interpret "=MAX(V(10+B3):V(10+B4))"

if anyone knows anything that may help me with this is would be very
very greatful

thanks in advance

Owen


--
owen080808
------------------------------------------------------------------------
owen080808's Profile:
http://www.excelforum.com/member.php...o&userid=32984
View this thread: http://www.excelforum.com/showthread...hreadid=528109

Finding max from different ranges of data
 

Thanks

I have been able to get it to work using this, i am very greatful for
your knowledge!

But i have now reached another problem, is it possible to get excel to
return info on which row the max it has found appears in (if it could
say max between 6130 and 6154 lies in cell 6144 for example)

any info would be great

Thanks again
Owen


--
owen080808
------------------------------------------------------------------------
owen080808's Profile: http://www.excelforum.com/member.php...o&userid=32984
View this thread: http://www.excelforum.com/showthread...hreadid=528109