Hi All
I am aware you can use Lookup to find the last value in a range (which also takes into account the possibility of there being blank values in between the data points), however it does not work with the offset function. I want to use offset to return the Month End.
Any ideas?
Best, Mizogy
I am aware you can use Lookup to find the last value in a range (which also takes into account the possibility of there being blank values in between the data points), however it does not work with the offset function. I want to use offset to return the Month End.
Any ideas?
Best, Mizogy