Hello
I am trying, and failing, to combine two codes.
The first is a vlookup I got from here, it subtracts from a time value the time value next to the unique ID to its left matched in the data on the other sheet.
Whilst this is good, and I could probably use it to complete most of the work, I am trying (mainly out of curiosity) to go further and have it automatically go to the next instance of the ID if the ID is not unique. For this I found a code on the other forum linked below, which seems to return the next match. It's a little beyond what I know and I'm struggling to understand it enough to alter it's use.
If anyone feels like giving this a shot, many thanks in advance.
http://www.excelforum.com/excel-gene...-function.html
http://www.mrexcel.com/forum/showthread.php?t=11137
Bookmarks