Results 1 to 4 of 4

Finding patterns in a list of numbers for EXCEL spreadsheet

Threaded View

  1. #1
    Registered User
    Join Date
    12-24-2018
    Location
    London, England
    MS-Off Ver
    Office 360
    Posts
    10

    Finding patterns in a list of numbers for EXCEL spreadsheet

    Hello

    I have a group of say 100 random integer numbers ranging from 0 to 40 (inclusive). (The numbers can repeat themselves)


    I want Xcel to tell me
    How many integers appeared consecutively as even numbers and odd numbers.

    Also how many numbers appeared consecutively with a value as less than 20 and how many with a value greater than 20

    Let the ZERO be both ODD/EVEN and have a value greater/less than 20 in any sequence.

    Say numbers are:
    5
    23
    39
    2
    0
    2
    2
    0
    15
    19
    33
    31
    33
    and so on

    In the example above :

    2 and 3 integers appeared consecutively that were above the value of 20. That is the 23, 39 and the 33, 31, 33


    3 and 6 integers appeared consecutively that were ODD. That is the 5, 23, 39 and the 0, 15, 19, 33, 31, 33


    5 integers appeared consecutively that were EVEN. That is the 2, 0, 2, 2, 0



    Thank you for your help


    PS I haven't got a clue about how to use EXCEL really so if you can help me with which cell to insert which formula that would be great
    Last edited by Herotrader; 12-24-2018 at 08:36 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel finding patterns across data range
    By hazzaska in forum Excel General
    Replies: 5
    Last Post: 04-21-2017, 02:42 AM
  2. finding the frequency of patterns in data set
    By fatterthanelvis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2016, 08:28 AM
  3. Macro For Advance Math Sequences In Finding Number Patterns or Missiing Numbers
    By Daddy007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2016, 06:44 PM
  4. Finding Patterns in String of Text in One Column
    By HDTV in forum Excel General
    Replies: 3
    Last Post: 10-08-2014, 08:03 AM
  5. [SOLVED] finding patterns in a range of cells
    By shart2k12 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-27-2013, 11:07 AM
  6. Finding patterns
    By GaidenFocus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-06-2012, 03:59 PM
  7. Finding same patterns in groupings of cells
    By modoud in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2007, 01:19 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1