Forum Discussion
Excel Formula Help
mtarler Dear Team; Thanks for jumping in to help me out... I am attaching version 2, with absolute values for the whole data...
Let me make it more open...
Is this possible to get date from last activity of relative SAN??? Whatever is the last activity...
Forget about lookup and any formula I already shared... I don't want to get max date from the column against relative SAN ID... I just want next activity to find previous activity, get its date & time and add 1 sec to it and done...
There will be 1000s of SANs with multiple activities daily... You can suggest sorting type too, either SAN based or activity date...
Regards
shahzad_afzal I looked at your new sample sheet and the 1st table with Absolute and Relative reference seems to do what you want. Is there a problem with that? I still don't know what was not working with the original lookup (using abs and relative references) in the original sample sheet. I have attached a sheet with multiple variations for the START TIME using each of the formulas. all of them except the fully absolute reference seem to work. Let me know what isn't working if needed, but I think the last one I gave is the most 'robust' solution. I attached the file and included an conditional formatting that highlights any START TIME that is > END TIME to highlight problems. That highlighted the first row because the New Addition Date is actually after the END TIME.