Results 1 to 8 of 8

Detecting where the sequence changes

Threaded View

  1. 12-13-2018, 02:09 PM #1
    Median
    Median is offline
    Forum Contributor
    Join Date
    01-26-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    312

    Detecting where the sequence changes

    Hi everyone,

    Hopefully a simple problem!

    I'm looking to find the first time a number changes in a sequence - this change could be +ve or -ve (hence my issue)

    r7oumjbhQna3aUxg0YI_pw.png

    As the screenie suggests, the answer I'm looking for is 215

    Any questions pop em below

    Ty

    Mdn
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Find a short-sequence in a longer sequence (Clash Royale Chests Challenge)
    By GeneralDisarray in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2016, 12:20 PM
  2. Need a code to print Alphabet sequence also number sequence simultaneously in a column
    By prat123 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-08-2015, 08:39 AM
  3. [SOLVED] Creating a sequence based on numbers in one column and adding "01,02..." to a new sequence
    By JCR1968 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2013, 08:06 AM
  4. Creating an alphanumeric sequence using a column that determines the sequence
    By csstewar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-12-2012, 06:39 PM
  5. [SOLVED] Detecting a value in a range
    By michaelt721 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2012, 03:40 AM
  6. Detecting same value in 3 cells
    By Excript in forum Excel General
    Replies: 11
    Last Post: 03-12-2009, 06:14 AM
  7. Detecting Top of Page
    By ffffloyd in forum Excel General
    Replies: 2
    Last Post: 02-08-2009, 08:50 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