Results 1 to 7 of 7

Find location and number of consecutive occurrences of 1 repeated ≥25 times in a column

Threaded View

montana7244 Find location and number of... 09-03-2020, 05:55 PM
XOR LX Re: Find location and number... 09-04-2020, 02:02 AM
montana7244 Re: Find location and number... 09-05-2020, 04:15 PM
XOR LX Re: Find location and number... 09-06-2020, 10:16 AM
montana7244 Re: Find location and number... 09-07-2020, 05:46 PM
XOR LX Re: Find location and number... 09-08-2020, 12:28 AM
montana7244 Re: Find location and number... 09-08-2020, 03:13 PM
  1. #5
    Registered User
    Join Date
    08-30-2020
    Location
    New York
    MS-Off Ver
    2020
    Posts
    6

    Re: Find location and number of consecutive occurrences of 1 repeated ≥25 times in a colum

    Hi,

    The adjustment worked for everything but the last 3 cells (D11:D13). These last 3 cells say "25" for number of occurrences, when they are actually 117, 78, and 111 respectively.
    This is happening because the formula is encountering some error, causing it to give the content (25) of cell C1 as the output. But I am not sure what the error is.
    I've attached the spreadsheet to show you what is happening.
    How do you fix this?

    Thank you!
    Montana
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Repeated words: remove duplicates, display word along with the number of times repeated
    By number9 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-24-2019, 03:32 PM
  2. Count the number of occurrences of consecutive absences
    By MissC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2017, 11:18 PM
  3. Count Repeated Occurrences in a Column
    By gra0001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2016, 08:00 AM
  4. Replies: 2
    Last Post: 11-30-2012, 12:48 PM
  5. Count the number of consecutive occurrences
    By timmycl_7 in forum Excel General
    Replies: 12
    Last Post: 05-03-2012, 02:04 PM
  6. Find 4 consecutive occurrences
    By swatsp0p in forum Excel General
    Replies: 8
    Last Post: 03-27-2010, 01:55 PM
  7. find out number repeated max. times in column.
    By vimivijay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2005, 06:59 AM

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