+ Reply to Thread
Results 1 to 2 of 2

Finding the last negative number in a column

Hybrid View

  1. #1
    Registered User
    Join Date
    03-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Finding the last negative number in a column

    I am having great difficulty in trying to write a formula to return the last negative number in a column.

    Essentially, I am working with a file that requires constant updating and as I add rows, numbers vary between negative and positive. I would like to write a formula the exists off to the side, that will give me the very last negative number.

    See below for an example

    A1 1
    A2 3
    A3 -5
    A4 -4
    A5 3
    A6 -2
    A7 3

    Below the data range, I'd like to write a formula that would tell me that -2 is the last negative number in the column.

    Thank you so much for the help!!!

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Finding the last negative number in a column

    Try this formula

    =LOOKUP(2,1/(A1:A7<0),A1:A7)

    adjust ranges as required
    Audere est facere

+ 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. [SOLVED] Selecting first negative number in a row and returning the associated column value
    By pdx-adm-trm01 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-10-2014, 12:55 PM
  2. Lookup largest number in a column treating negative number as postive number
    By xWiZardx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2010, 08:09 AM
  3. Find the first negative number in a column?
    By jerickson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2007, 09:13 PM
  4. [SOLVED] Negative Number column
    By go in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-27-2005, 09:20 PM
  5. [SOLVED] Negative Number put in a certain column in a different sheet.
    By naiveprogrammer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2005, 10:05 AM

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