Results 1 to 13 of 13

check value increase continuously

Threaded View

nalaka check value increase... 11-05-2011, 09:19 AM
jeffreybrown Re: check value increase... 11-05-2011, 09:29 AM
nalaka Re: check value increase... 11-05-2011, 10:21 AM
TMS Re: check value increase... 11-05-2011, 01:15 PM
nalaka Re: check value increase... 11-06-2011, 12:49 AM
Marcol Re: check value increase... 11-05-2011, 02:56 PM
TMS Re: check value increase... 11-05-2011, 03:25 PM
Marcol Re: check value increase... 11-05-2011, 07:25 PM
TMS Re: check value increase... 11-05-2011, 07:59 PM
Marcol Re: check value increase... 11-06-2011, 07:01 AM
nalaka Re: check value increase... 11-06-2011, 11:27 AM
TMS Re: check value increase... 11-06-2011, 11:34 AM
Marcol Re: check value increase... 11-06-2011, 01:43 PM
  1. #10
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: check value increase continuously

    Okay that's the third time the rules have changed.

    Try this
    With your Names in Column A and your data beginning in Column C
    In B1
    =IF(SUMPRODUCT(--(C1:R1>0),--(D1:S1>0)-1)=-1,"Yes","No")
    This will handle up to 16 numbers per row.

    Or a dynamic solution
    =IF(SUMPRODUCT(--(C1:INDEX(1:1,1,MATCH(99^99,1:1,1))>0),--(D1:INDEX(1:1,1,MATCH(99^99,1:1,1)+1)>0)-1)=-1,"Yes","No")
    The number of entered numbers per row is only limited by the sheet width
    Attached Files Attached Files
    Last edited by Marcol; 11-06-2011 at 07:04 AM.

Thread Information

Users Browsing this Thread

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

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