I have a column of data and a time stamp for a test performed over several minutes. The test consists of multiple bursts of data over this time period. I need to analyze each burst of data and compare statistics between bursts.
The problem is that the data has an irregular number of points. Each burst is separated by a few seconds, so I can use the time stamp to group the data. However, I haven't figured out how to make that work.
I can use the DIF function to figure out the transitions between groups, but I do not know how to increment a group number at this transition.
The goal would be to have a group number for each burst of data. Any ideas? I'm pretty handy with formula's but haven't done any scripting yet.