Average Min: 0.9C
Average Max: 11.1C
Mean: 6.0C

Lowest Min: -4.7C (28th)
Highest Min: 12.7C (2nd)
Lowest Max: 2.9C (25th)
Highest Max: 18.2C (2nd)

Precipitation: 78.0 mm

Lowest Pressu 992.3 mb (23rd)
Highest Pressu 1039.5 mb (25th)
Mean Pressu 1016.4 mb

Air Frosts: 14
Snow Cover (50% at 9am): 1 day
Snow Falling: 2 days
________________
Nick G
Exe Valley, Devon
50 m amsl

In uk.sci.weather on Thu, 1 Dec 2005 at 10:11:31, Nick G wrote :

Lowest Pressu 992.3 mb (23rd)
Highest Pressu 1039.5 mb (25th)

Shouldn't those dates be the opposite way round?
--
Paul Hyett, Cheltenham

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

In uk.sci.weather on Fri, 2 Dec 2005 at 09:48:29, Nick G wrote :
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

I plot a graph of the hourly readings each month, so I just have to look
at that - much easier than scanning a page of numbers!
--
Paul Hyett, Cheltenham

"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.
--

In uk.sci.weather on Fri, 2 Dec 2005 at 19:16:29, Will Hand wrote :

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.

This just reminds me there are so many excel functions I don't know
about.
--
Paul Hyett, Cheltenham

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.
--