LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
ERC ERC is offline
external usenet poster
 
Posts: 4
Default data reduction--goal:unique time data only

I am a total Excel/programming novice. I am having a lot of trouble
constructing the simplest macro, and I would love some help. What I
have is a piece of equipment that records the time and extention of a
sample six times a minute, so that the extracted data is something
like:

A B
0.0000 -8.1000e-3
0.0100 -4.5000e-3
0.0100 -1.8000e-3
0.0100 -1.5000e-3
0.0200 -1.8000e-3
0.0200 -1.4000e-3
0.0200 -1.5000e-3
0.0300 -1.0000e-3
0.0300 5.0000e-4
0.0300 2.7000e-3
0.0400 3.7000e-3

Obviously, if this recording goes on for hundreds of hours, it would
result in way to many points to be meaningful. I need to write a macro
that either identifies unique times (I've tried sorting for unique
values, but since the data in column B is different, this doesn't work)
and only retains one point per minute, or, best case scenario, compares
the difference in B column values, and only retains points that meet a
certain minimum difference, so that I only keep points that change
the inflection of the curve. I only need a basic shape; reducing each
data set to 100 points or so would be ideal.

Any help would be fabulous; I'm a graduate student with no experience
in this area whatsoever.

 
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
Filer for unique records and return all column data for unique rec bseeley Excel Discussion (Misc queries) 1 September 12th 09 12:17 AM
comparing two columns of data and return unique data in another co ExcelUSER Excel Discussion (Misc queries) 6 June 18th 09 02:10 PM
Adding data to existing data that has a unique number in column Lars Excel Discussion (Misc queries) 3 June 28th 07 11:48 AM
Average data/reduction MC New Users to Excel 2 January 9th 06 03:19 PM
Goal Line in chart but not on data tabel BMSpell Charts and Charting in Excel 1 February 1st 05 06:41 PM


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