Hi Nick,

Use the MATCH function in Excel. i.e. use the MAX function to work out the
highest, store that in a cell, then use MATCH to find which of an array of
cells matches it, place that output in the cell adjacent to the one
displaying the max. value.

Thanks Will.

I have tried to use the MATCH with the MIN/MAX functions before but got
nowhere with it, but I can see where I went wrong by your instructions.
_______________
Nick G
Exe Valley, Devon
50 m amsl

"Will Hand" wrote in message
...

"Nick G" wrote in message
...
Lowest Pressu 992.3 mb (23rd)
Highest Pressu 1039.5 mb (25th)

Shouldn't those dates be the opposite way round?

Aye, Paul you're right. I add the dates by hand as I haven't figured out
yet
how to get the spreadsheet to give me the actual date alongside the
pressure
that the extremes occur, so it is open to me making a balls-up from time
to
time.
________________
Nick G
Exe Valley, Devon
50 m amsl




There you go,

Will.
--