Find last value in column if a positive number

**nickpavlov** · 05-24-2019, 05:32 PM

Hello,

I am using this formula

=LOOKUP(2,1/(C:C<>""),C:C)

Can it be modified to lookup the last positive number in a column?

Thanks for any help,
Nick

**protonLeah** · 05-24-2019, 08:07 PM

=lookup(2,1/((c:c<>"")*(c:c>0)),c:c)

**nickpavlov** · 05-24-2019, 08:15 PM

Excellent! Thank you PMprotonLeah

Find last value in column if a positive number

LinkBack

Thread Tools

Rate This Thread

Display

Find last value in column if a positive number

Re: Find last value in column if a positive number

Re: Find last value in column if a positive number

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find which combination of columns will add to get the most number of positive numbers

Find next positive number in column after specified vaue

[SOLVED] Sum the first x number of positive values in a column

[SOLVED] How to find smallest positive number in a column which also has -ve values ?

Carrying Over Negative number to next column as a positive number

sum only positive number in skip column

How to find the largest number whether negative or positive out of a range of values

Bookmarks

Bookmarks

Posting Permissions