#1
|
|||
|
|||
Need help identifying numbers within a 20s range
My raw data is simply time in seconds. Each row is an event that is either real or not. I need to separate the "real" events from the "non-real" events. "Real" events are either: 1. the first event 2. any event that occurs >20 seconds after another "real" event.
I made a column that simply subtracts the time of a suspected event from the value above. This identifies the majority of "real" events, but misses other "real" events. I can check the "non-real" events by hand, but I have data sets with thousands of suspected events. I was hoping to find some kind of formula to speed this analysis. Any help is appreciated! I've attached a data set including my raw data (column A), my current analysis (columns B-D), and identified which events were missed by my initial analysis (columns E and F). |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
unable to get around using index and match to find with range of numbers | ozmozmozm | Excel | 8 | 09-26-2016 06:35 PM |
find IP in range / find number between numbers | gn28 | Excel | 4 | 06-14-2015 03:46 PM |
Identifying Postcodes. | Chayes | Word VBA | 13 | 09-21-2013 06:29 AM |
Identifying and counting words | monique | Word | 1 | 08-30-2012 05:33 AM |
Identifying the Dynamic Connector | cyberbhai | Misc | 0 | 12-14-2005 03:55 AM |