+ Reply to Thread
Results 1 to 7 of 7

Find consecutive 15 positive or negative numbers in a column

  1. 11-19-2013, 12:57 AM #1
    Sarangsood
    Sarangsood is offline
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Find consecutive 15 positive or negative numbers in a column

    Hi all,

    I want to find 15 positive or negative numbers in a column. Also please check the attached sheet as well.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-19-2013, 01:27 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Find consecutive 15 positive or negative numbers in a column

    Hi,

    See if this attached, with a helper column helps answer your question. No VBA code changed.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 11-19-2013, 02:39 AM #3
    Sarangsood
    Sarangsood is offline
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Re: Find consecutive 15 positive or negative numbers in a column

    @marvinP : i only want positive or negative consecutive values. For eg in the sheet from B10:B24 there are 15 consecutive positive values. So i want a formula to tell me that.
    Reply With QuoteRegister To Reply
  4. 11-19-2013, 02:53 AM #4
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Find consecutive 15 positive or negative numbers in a column

    Hi,

    I'm sorry but I just don't understand the question. How about a few examples with answers so we can get what you mean by your question.
    Reply With QuoteRegister To Reply
  5. 11-19-2013, 03:47 AM #5
    Sarangsood
    Sarangsood is offline
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Re: Find consecutive 15 positive or negative numbers in a column

    may be the attached sheet can explain
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 11-19-2013, 04:18 AM #6
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Find consecutive 15 positive or negative numbers in a column

    Don't know if this is what you want.

    Book1 (1).xlsm
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  7. 11-19-2013, 05:26 AM #7
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Find consecutive 15 positive or negative numbers in a column

    Pl see the attached file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count Consecutive Positive/Negative numbers
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2013, 01:02 PM
  2. Sum of time for consecutive positive/ negative numbers
    By DexterG in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-25-2012, 04:03 AM
  3. [SOLVED] Counting last (most recent) consecutive positive or negative numbers in a row
    By damianberry in forum Excel General
    Replies: 6
    Last Post: 11-13-2012, 07:33 AM
  4. Count number of instances in which two consecutive numbers in a column are positive
    By DavidHD in forum Excel General
    Replies: 5
    Last Post: 09-01-2011, 03:46 AM
  5. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1