xl-central.com, Your Quick Reference to Excel Solutions





navleft
navright
spacer
Lookup the Last Non-Zero Value

Lookup the Last Non-zero Value

The following formula returns the last non-zero value from B2:B10...

=LOOKUP(2,1/(B2:B10<>0),B2:B10)

Based on the sample data, the formula returns 2.  Sample Workbook



spacer
Wu Yi Tea
Website Designed by Wu Yi Tea
Design downloaded from free website templates.
Wordpress Themes