+ Reply to Thread
Results 1 to 4 of 4

first negative- condition that the number in same row in another column is positive

  1. #1
    Registered User
    Join Date
    05-28-2012
    Location
    india
    MS-Off Ver
    Excel 2019
    Posts
    13

    first negative- condition that the number in same row in another column is positive

    hello

    I am requesting help to establish a formula to find the first negative in a column subject to the condition that the corresponding number in the same row but in another column is positive.

    It will be of great help.

    Thank you all ever so much for all your previous helps.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,981

    Re: first negative- condition that the number in same row in another column is positive

    For future reference, it's always easier with a sample sheet (see yellow banner at the top of the page).

    =INDEX($A$2:$A$16,MATCH(1,INDEX(($A$2:$A$16<0)*($B$2:$B$16>0),0),0))
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    05-28-2012
    Location
    india
    MS-Off Ver
    Excel 2019
    Posts
    13

    Re: first negative- condition that the number in same row in another column is positive

    thank you so so much
    yes i am sorry i missed the yellow banner directions
    thank you again
    regards

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,981

    Re: first negative- condition that the number in same row in another column is positive

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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] How to sum a positive and negative number so the total is positive
    By jminty95 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-15-2017, 09:27 PM
  2. CountA - stop counting in column when number changes positive or negative
    By Hallgente in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-26-2016, 01:04 PM
  3. Carrying Over Negative number to next column as a positive number
    By Redraven in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2014, 06:39 AM
  4. [SOLVED] SUMIF positive and negative numbers - take double a negative number?
    By Zordrail in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2014, 08:34 AM
  5. Replies: 5
    Last Post: 07-15-2013, 01:24 AM
  6. Replies: 1
    Last Post: 11-20-2008, 01:52 AM
  7. Replies: 2
    Last Post: 11-13-2008, 12:35 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