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