Results 1 to 7 of 7

Counting last (most recent) consecutive positive or negative numbers in a row

Threaded View

  1. #6
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Counting last (most recent) consecutive positive or negative numbers in a row

    i understand that you try to simplify the example, but many factors can affect the results. like the change in column or if there's a formula in it. you can still do up a sample, but considering all these factors if possible. i do love reading a simplified eg. try these now:
    =IF(INDEX($F$53:$S$53,COUNTIF($F$53:$S$53,"<>0"))>0,COUNTIF(F53:S53,"<>0")-MAX(IF($F53:$S53<0,COLUMN($F53:$S53)-5)),"")
    =IF(INDEX($F$53:$S$53,COUNTIF($F$53:$S$53,"<>0"))<0,COUNTIF($F$53:$S$53,"<>0")-MAX(IF($F53:$S53>0,COLUMN($F53:$S53)-5)),"")
    Last edited by benishiryo; 11-13-2012 at 07:12 AM.

Thread Information

Users Browsing this Thread

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

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