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. #1
    Registered User
    Join Date
    08-30-2020
    Location
    New York
    MS-Off Ver
    2020
    Posts
    6

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

    Hi,

    I have Column A with numbers 1,2,3,etc to signify the location of cells in Column B. In Column B, I only have 0s and 1s. I want to identify where in Column B "1" consecutively appears 25 or more times, and how many times it appears. So if 1 appears 27 times beginning where Column A says 5, I would like Excel to paste the number 5 (and subsequent numbers where 1 appears≥25x) to Column D, and also 26 in Column E.
    I have attached an example workbook showing this.

    I did some research and found some answered questions that might help:

    "Counting the number of consecutive occurrences" by timmycl_7 on Excel forum could be useful
    I think the above link would really help with my problem, but I can't figure out how to apply it to my data (Excel newbie here). The forum won't let me attach my link because I am a new user.

    This might also be helpful:
    "Counting streaks in Excel" by Danielpeam

    I would be grateful for any ideas and answers!
    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