LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Finding a Maximum amount of a part of the data

I have a problem here....
I have a two columns data, one column shows the data and time, with the
interval of 10 seconds each, and the other column shows the noise level data
( all in the renge of 40 to 100) at the perticular time,
now the it has only got two columns but the data is very big, with total of
40,000 data,
so for each minute there is total 6 noise level data.
what I want is to find a maximum noise level for every 15 minutes data, that
means a maximum noise level for each 90 points data....
I dont know how to do that....
Regards
 
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
Maximum amount allowed Wannano Excel Discussion (Misc queries) 1 March 13th 07 07:25 PM
Maximum amount of macros supported Bror Excel Discussion (Misc queries) 2 August 19th 06 03:10 AM
What is the Maximum amount of sheets in a workbook? Ant Excel Discussion (Misc queries) 1 April 6th 06 11:57 AM
Finding maximum of various ranges of data thekovinc Excel Discussion (Misc queries) 2 January 23rd 06 08:41 PM
formula that includes a maximum amount fbcmusicmark Excel Worksheet Functions 5 December 6th 05 11:25 PM


All times are GMT +1. The time now is 06:54 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"