Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-10-2017, 02:34 PM
rebs2017 rebs2017 is offline Need help identifying numbers within a 20s range Windows 10 Need help identifying numbers within a 20s range Office 2016
Novice
Need help identifying numbers within a 20s range
 
Join Date: Mar 2017
Posts: 1
rebs2017 is on a distinguished road
Default 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).
Attached Files
File Type: xlsx Short example dataset for practice.xlsx (12.7 KB, 14 views)
Reply With Quote
Reply

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
Need help identifying numbers within a 20s range Identifying Postcodes. Chayes Word VBA 13 09-21-2013 06:29 AM
Need help identifying numbers within a 20s range 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft