I have two pieces of data that are unique on their timestamps and are located on separate sheets.
The first piece of data is a series of events that occur at a particular time these are stored in sheet Trigger
The second piece of data is continuous series of data that is captured every couple of seconds this is stored on a sheet called Load
I would like to create a new column on the Load sheet that will indicate when a value occurred from the Trigger data.
One issue is the Trigger data will often occur between timestamps (but not always) on the Load data. IE
Please see sample file.
The sample file hold the data and an example of what I would like to achieve.
All I really need is to be able to identify if a count range in the Load sheet doesn't align with a trigger the solution doesn't need to be an exact match to the example. IE put trigger in the column.
I am using excel 2013 for the sample.