Require last non zero values corresponding sl no in case of multiple entries.

**Tony Valko** · 10-19-2013, 03:01 PM

Not sure I understand you but here's my best guess...

=LOOKUP(2,1/(B10:B1000<>0),A10:A1000)

**projectatpel** · 10-19-2013, 03:08 PM

thanx for the help, but actually
=LOOKUP(2,1/($B$10:$B$1000<>0)/($B$10:$B$1000<>""),$A$10:$A$1000)
this is working.
I derived this from what you posted @Tony valko Thanx again.

**Tony Valko** · 10-19-2013, 04:41 PM

Good deal. Thanks for the feedback!

Require last non zero values corresponding sl no in case of multiple entries.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Require last non zero values corresponding sl no in case of multiple entries.

Re: Require last non zero values corresponding sl no in case of multiple entries.

Re: Require last non zero values corresponding sl no in case of multiple entries.

Thread Information

Users Browsing this Thread

Similar Threads

Sum values based on multiple date entries

Vlookup values with Multiple entries

[SOLVED] Require Help - Require Formula for Multiple values in both columns

Multiple Values Corresponding Cells with Blank Entries Between

Require a lookup to return multiple values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions