LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated Formula to Distinguish, weather the License is Valid o Khalid A. Al-Otaibi Excel Discussion (Misc queries) 6 March 15th 10 06:39 AM
Automatic weather Damian Excel Discussion (Misc queries) 6 August 27th 09 02:41 PM
Importing Weather Info kpack Setting up and Configuration of Excel 1 November 8th 08 02:54 AM
Weather Chart David D Charts and Charting in Excel 3 December 5th 05 03:39 PM
Weather counting query Weather Consultancy Services Excel Discussion (Misc queries) 1 July 30th 05 10:35 PM


All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"