Hi all,
I'm wondering if anyone can help me out. I've attached a sample of data that I'm working with, what I've got done so far and what I'm after. That's the top line of the issue and I'll explain now the data.
The raw data is in F1 to L21, this is a small subset and the actual data can run into the thousands of lines. I have then created some 'helper' columns in A to D to try and get the information I need to look for. What the checks are doing is looking at column F to see if the same voltage appears 3 or more times in a row, if it does then it'll mark an occurrence in A and this self increases per occurrence it finds. Column B finds where the sequence starts which is always a value of 1. Column C then shows the consecutive number of how many in a row appear the same and finally, column D is the marker of when the sequence ends with the total number of steps.
In cells O1 to T4 I've put in the data I can pull out with VLOOKUP and this is where I am now hitting an issue. I want the data to appear as shown in cells O14 to T17. The duration is easy to work out once I have the 'Date / Time of Last Entry' populated but that's where I'm having the issue (I can live within the 'Number of Entries' if that's too awkward to solve).
Any idea? The number of consecutive can be any number with some of the raw data I've been looking at having some at 160, 116, 80 etc... so I can't hard code in a certain offset to use with INDEX/MATCH.
Hope this does explain it well enough and the example data attached helps, but if any questions please let me know.
Thanks in advance for any help that can be given.
Bookmarks