Results 1 to 9 of 9

Finding Negative Numbers

Threaded View

  1. #1
    Registered User
    Join Date
    05-16-2017
    Location
    Ankara,Turkey
    MS-Off Ver
    2016
    Posts
    20

    Finding Negative Numbers

    I have this sheet.

    If there is/are negative number(s) between DATA cells written A Column, I want spot them writting YES or NO

    As seen at the example:

    - There is no negative number between A1:A3 so when DATA is written NO must be written just next cell (B3)

    - There is no negative number between A3:A13, the result is same

    - There is one negative number (A20) between A13:A26, YES is written next cell (B26)

    I can arrange A column. The question is this:

    What kind of function must be written at the B Column that;

    When does Excel spot the "DATA", Excel must search the field between the last two DATA cells and if there is negative number or not, YES or NO must be written in the cell just next the last DATA cell ?

    Thanks a lot for help.

    DATA.jpeg
    Last edited by excelman13; 09-30-2018 at 02:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 09-24-2018, 09:26 AM
  2. Replies: 9
    Last Post: 04-20-2016, 02:42 AM
  3. [SOLVED] Finding average value for the positive and negative set of numbers
    By thilag in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-26-2014, 04:39 AM
  4. [SOLVED] Need help with finding first negative value in a list of numbers
    By Good 4 Me in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-30-2014, 08:31 PM
  5. [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
  6. Replies: 1
    Last Post: 11-20-2008, 01:52 AM
  7. finding out pairs of positive & negative numbers!
    By via135 in forum Excel General
    Replies: 11
    Last Post: 12-18-2005, 02:27 AM

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