Hi,
It would be great to have some insight to help solve my problem below...
I am looking at comparing time data within each cell of range (A) to another range (B) to see if there are any matches in range B within 5 minutes of range A. The 5 minute tolerance is not absolute so can be 2 minutes after for example. As an output a simple denotation of matching criteria would be sufficient "x" with non matching data being left blank. So far i have the following formula which is not correct but perhaps explains the formula better...
=VLOOKUP((IF(ABS(G4<(G4+"00:05"),G4>(G4+"00:05"),"x"),E:E,1,FALSE)
I would really appreciate any help on this issue
Many thanks
Bookmarks