last number above zero in long column

**jrtaylor** · 06-05-2017, 06:02 PM

I have a long column of cells. Some have numbers, some are 0.

I need to detect the last number in this column. It will be among the last 20 rows.

I've tried something like this without success:

Please Login or Register  to view this content.

. (the result is blank).

Any suggestions?

Thanks.

**sandy666** · 06-05-2017, 06:12 PM

try: =LOOKUP(2,1/(AT:AT<>0),AT:AT)

**jeffreybrown** · 06-05-2017, 06:14 PM

Maybe...

=LOOKUP(9.999999999999E+307,IF(AT2:AT32>0,AT2:AT32))

Confirm with Ctrl + Shift + Enter

**jrtaylor** · 06-05-2017, 06:17 PM

Yes, first solution worked. Also will try other. Thanks so much!

**sandy666** · 06-05-2017, 06:21 PM

you are welcome

if problem is resolved read my dancing footnote here or above

last number above zero in long column

LinkBack

Thread Tools

Rate This Thread

Display

last number above zero in long column

Re: last number above zero in long column

Re: last number above zero in long column

Re: last number above zero in long column

Re: last number above zero in long column

Thread Information

Users Browsing this Thread

Similar Threads

Need formula for substracting the number “9” to each number inside a long number and more.

Break long column into a specified number of rows

HOw can I take Long column of Data to convert to number Quickly!

Flag the smallest number in a recurring set of 6 numbers in a long column in the adjacent

[SOLVED] =IF and =SUMIF formulas creating long long long data processing times.

[SOLVED] Count Duplicates in Column A once as long as there is a number higher than 0 in Column B

Need to Count Number of Unique Text Values as Long as Date is Same in Column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions