+ Reply to Thread
Results 1 to 5 of 5

last number above zero in long column

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    2016
    Posts
    624

    last number above zero in long column

    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.
    Last edited by jrtaylor; 06-05-2017 at 06:18 PM.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: last number above zero in long column

    try: =LOOKUP(2,1/(AT:AT<>0),AT:AT)
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,083

    Re: last number above zero in long column

    Maybe...

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

    Confirm with Ctrl + Shift + Enter
    HTH
    Regards, Jeff

  4. #4
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    2016
    Posts
    624

    Re: last number above zero in long column

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

  5. #5
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: last number above zero in long column

    you are welcome

    if problem is resolved read my dancing footnote here or above

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 17
    Last Post: 05-16-2016, 01:22 AM
  2. Break long column into a specified number of rows
    By rcarter86 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-03-2015, 06:26 PM
  3. HOw can I take Long column of Data to convert to number Quickly!
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2015, 07:19 PM
  4. Replies: 8
    Last Post: 04-25-2014, 05:26 PM
  5. [SOLVED] =IF and =SUMIF formulas creating long long long data processing times.
    By comp in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 03-26-2014, 02:59 PM
  6. [SOLVED] Count Duplicates in Column A once as long as there is a number higher than 0 in Column B
    By armbands1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2013, 01:46 AM
  7. Replies: 12
    Last Post: 07-03-2012, 04:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1