Results 1 to 12 of 12

Check for 5 consecutive identical values

Threaded View

  1. 03-25-2016, 08:42 PM #1
    mychael14
    mychael14 is offline
    Registered User
    Join Date
    08-21-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    9

    Question Check for 5 consecutive identical values

    Hi everyone... can I ask a question. How can I check for 5 consecutive identical values in may table. The formula should return true or false.
    Here's what I want to achieve in column J. I tried searching the internet and maybe it something to do with the function FREQUENCY but I'm not familiar with that function. Thank you.
    A.PNG
    Attachment 452831
    Attached Images Attached Images
    Last edited by mychael14; 03-25-2016 at 09:27 PM.
    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. [SOLVED] Numbering consecutive identical cells in a column
    By boomcie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2015, 07:54 AM
  2. [SOLVED] Totalling consecutive identical rows out of a huge sheet
    By spursfan323 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-26-2013, 06:53 AM
  3. Excel 2008 : Finding Consecutive Identical Upper Case Letters
    By mikeaq in forum Excel General
    Replies: 17
    Last Post: 05-20-2011, 01:48 AM
  4. Check for seven or more consecutive negative values?
    By Andersth in forum Excel General
    Replies: 6
    Last Post: 09-13-2010, 08:50 AM
  5. Check Userform controls for identical values
    By Newbie_Nick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2010, 01:44 PM
  6. Flaging identical data in 3, 5 and 20 consecutive cells in a column
    By SNarfel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2007, 05:23 PM
  7. [SOLVED] Need to find two consecutive identical cells (in a column).
    By How did I get here? in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-03-2006, 03:15 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