View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wally3178 Wally3178 is offline
external usenet poster
 
Posts: 8
Default Adding dates to events

Hi,

I have built a spreadsheet for recording daily weather observations and am
in the process now of refining some of the features.

I have a display on the sheet for the highest and lowest temperatures of the
year but I don't seem to be able to link them to a date. Example, "The
highest temperature for the year was 45.6C on ?" I am using the 'max'
function to give me the temp can anyone suggest how I might be able to
complete the date?

Cheers,

Wally
--
Wal