Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
comparing two columns of data and return unique data in another co | Excel Discussion (Misc queries) | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
Average data/reduction | New Users to Excel | |||
Goal Line in chart but not on data tabel | Charts and Charting in Excel |