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

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