Find last value in a column of formula derived values.

Hi zbor, Many thanks. I tried this in the workbook in question and that didn't work either. I also, for the sake of proper testing, tried it in another workbook under similar circumstance and it worked! In the original, I've checked all the obvious format issues and cannot find the reason it won't work. I also tried the formula in completely different cell away from the work area and again, it won't work. Bizarre! I'll keep looking for the answer and post it should I find one! Unfortunately I cannot post the workbook as it contains sensitive information.

I've checked, checked and checked again all of the obvious errors (such as the one you mention zbor) and still no joy. I'll keep at it or change the structure!
Hey, Fotis, good to hear from you!

Hi zbor, I really appreciate your help - thanks! I have resolved the problem by changing the structure of my sheet although I was unable to resolve the odd issue of the formula not working. I tested the same formula in other similar workbooks and it worked fine but not in the 'problem' workbook which is really weird. I have checked for everything that I can think of including formatting, characters in places they should not be and I'm satisfied that there is an odd quirk with this particular workbook. Unfortunately due to the sensitive nature of the book, I cannot post it here. It's impossible (without much work) to desensitize the information. Thanks again.

Problem solved - not by me I hasten to add! I had the sheet set not to show zero values!! Simple (like me). Sorry and thanks both.

Thanks Fotis!