Search results

What i did notice that the timesheet data needs to be in date / time order, otherwise it tends to fall over...and the named ranges also needs to be aligned correctly otherwise you end up getting the wrong row detail. if anyone is going to replicate this, please check and validate random rows /...

it works, i slipped up with the events named range!!!

hmmmn. still getting #ref!.... i have a feeling that the named ranges might not be looking at the right sections, but have tried all possible combinations.( named cells are correct as have checked this using other simple formulas).... to check i did remove 'iferror'...

Hi Narayan, I've tried your formula but am getting #ref!. what would cell A1 refer to? am i able to attached the sample workbook?

Thanks Narayan this is one heck of a long formula. i presume you have referred to 'events' as a named range

Thanks for replying Jason. I've thought of index & match too, but its would only return what it matches directly. i need it to look for the next time above, and as 15:50 would not directly exist in the time sheet WB then it would not be able to match .... correct me if I'm wrong..

Hi, This is my very first post, so apologies if I miss something, but will try to cover and clarify as much as I can. I have 2 excel workbooks. The first one has a list of names,dates and times and the other workbook has a list of names, dates and times also. The times in WB 1 is when a...

Hello All, looks like quite an intersting site, with all boffins clustered in!!. I'm an analyst with excel/access skills, and from time to time, get hammered with the almost impossible.....this place is gonna make it easy !!