+ Reply to Thread
Results 1 to 29 of 29

Find/count consecutive entries in a row in excel

Hybrid View

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,186

    Re: Find/count consecutive entries in a row in excel

    Right - so that's a completely different workbook.

    Provide the workbook in the image for testing, please. It looks like you have failed to adapt the formula for the new workbook correctly.

    At least we know that you are using MS365 - that's good.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  2. #2
    Registered User
    Join Date
    10-02-2021
    Location
    UAE
    MS-Off Ver
    2010, 2019, MS 365
    Posts
    17

    Re: Find/count consecutive entries in a row in excel

    I cant attach links yet as it doesnt allow me to. Can i upload a txt file with the link in it?

  3. #3
    Registered User
    Join Date
    10-02-2021
    Location
    UAE
    MS-Off Ver
    2010, 2019, MS 365
    Posts
    17

    Re: Find/count consecutive entries in a row in excel

    updated formula for the targeted cells
    Attached Images Attached Images

+ 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. Count consecutive > zero, ignore zero count consecutive > zero next cell
    By karl.smith in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-16-2020, 07:58 AM
  2. Find count of unique entries using vba
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 11-25-2019, 03:31 AM
  3. [SOLVED] Count Consecutive & Non consecutive days per given logic
    By asimraza89 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2019, 04:31 PM
  4. [SOLVED] Find last occurance of value in column and count entries below
    By terratushi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2019, 02:50 PM
  5. Replies: 1
    Last Post: 03-20-2015, 03:56 AM
  6. How to find the maximum count of consecutive occurances in an excel range
    By manojsinha2006 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-20-2015, 03:47 AM
  7. [SOLVED] Counting the number of entries in a column (but only once for consecutive entries)
    By 11416498 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-30-2014, 09:36 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