+ Reply to Thread
Results 1 to 1 of 1

How to find the most SEQUENTIAL occurring numbers in 1 column

  1. #1
    Registered User
    Join Date
    06-10-2019
    Location
    FL
    MS-Off Ver
    1
    Posts
    1

    How to find the most SEQUENTIAL occurring numbers in 1 column

    I am doing lottery odds on excel for fun.
    So I am doing a 5 column lottery.

    I am trying to figure out in Column I (Labeled 4th Ball)
    How to highlight the numbers that show up in a row the most
    frequently and to highlight them a certain color.

    For example, rows 20-22 all have the number 15 so that
    means that 15 occurs 3 times in a row (in these selected row).

    I want to know if there are any more that occur 4 times in
    a row or 5 times in a row. If not, I would need to know all of the
    times it occurs 3 times in a row.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to find most To most frequently occurring numbers in a column
    By eddie01001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2019, 07:32 PM
  2. [SOLVED] VBA code for sequential numbers for a column containing letters and numbers
    By YuriyBaron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2018, 10:03 PM
  3. [SOLVED] Find the most occurring values in Column A and consolidating each value's quantity
    By savagebabs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2014, 03:18 PM
  4. find and return sequential numbers
    By twisty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-27-2013, 10:43 AM
  5. Find most occurring text within a Table column
    By XxCMoneyxX in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-27-2012, 09:44 PM
  6. Replies: 4
    Last Post: 07-29-2012, 08:40 AM
  7. [SOLVED] Find missing sequential numbers
    By DTTODGG in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 03-09-2006, 09:00 PM

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