Hello Excel Folk,
I need help! I would like a function that will reference the next filled cell in a column and then have a lookup function with a subtraction in there as well that will essentially give you the different time spans between all repeating occurrences of the same event.
Its a little easier to understand in the test file I have attached. Thanks all!
Last edited by alecp; 01-30-2012 at 09:07 AM.
Hi
enter the formula in C2 and copy down
=IF(B2="","",INDEX(A3:$A$101,MATCH(1,B3:$B$101,0))-A2)
Sadath
Works like a charm! Thanks this will be useful to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks