I have some data in two columns, the first column of which are time stamps in 15 second increments. I want to create a second list that extracts some data from the second column but only those from 15 minute increments. I am using a vlookup function with Mround to extract the items, but only a few of the cells end up being populated with correct values, while the remainder show #n/a. I have formatted the time stamps with the same date formulae; further I have tested and find that the relevant time stamps being compared are equal -- see the small list comparing values. What am I missing? Thx
Bookmarks