"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



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.

There you go,

Will.
--