View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
betomovil betomovil is offline
external usenet poster
 
Posts: 1
Default Weather data Sorting with formula


I have a 2 year Weather database that i want to sort. The Weather
station takes data every 30 minutes. So I Get 48 lines per Day. What I
want to do in excel is to get the line with the higher temperature from
every day and take it to another worksheet so i can graph the high
temperatures monthly.
I have Several columns.

Date, Time, Outside Temp High Temp, Low Temp.

Any Ideas??


--
betomovil
------------------------------------------------------------------------
betomovil's Profile: http://www.excelforum.com/member.php...o&userid=24968
View this thread: http://www.excelforum.com/showthread...hreadid=384947