Get last item or number in range

[YasserKhalil]

Hello everyone
I have a range with formulas and I need to get the last occurrence of number in this range
My range is E2:E26 and in cell E27 I need to get the last number not the null as a result of formula
so in my example E27 should 16

[Pepe Le Mokko]

Have a look at http://www.xldynamic.com/source/xld.LastValue.html

[YasserKhalil]

Thank you very much for the link
Regards

[Pepe Le Mokko]

You're welcome