Results 1 to 13 of 13

Looking for a formula to count the number of times a specific value appears in sequence in

Threaded View

  1. 08-14-2020, 01:21 AM #1
    Lancasterbe
    Lancasterbe is offline
    Registered User
    Join Date
    05-10-2019
    Location
    New Zealand
    MS-Off Ver
    2016
    Posts
    31

    Looking for a formula to count the number of times a specific value appears in sequence in

    Hello Community
    I would like to request some help for the following
    I am looking for a formula that will give a total for the number of times a specific value appears in sequence in a column
    My spreadsheet that I need this for is several hundred rows long, so have included a sample. Column A is the data to work with,The correct answers are manually entered in Columns B and C
    Hope this makes sense
    Thank you in advance
    Cheers
    Brian
    Attached Files Attached Files
    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. Count number of times a specific text appears for a certain date
    By Alfie092 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2020, 12:25 PM
  2. Count number of times a specific word appears
    By csepesy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2017, 09:48 PM
  3. How do i count the number of times a sequence appears in a row of data
    By dony85 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-02-2014, 01:57 PM
  4. count the number of times a number appears in a specific range
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2013, 11:01 AM
  5. Count number a times a specific value appears consecutively.
    By kww0027 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2013, 06:17 PM
  6. Count A Number Of Times A String Appears but display the number sequence
    By Cozzy99 in forum Excel General
    Replies: 5
    Last Post: 11-22-2010, 06:31 PM
  7. [SOLVED] count the number of times a specific word appears in a column
    By BAR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2006, 12:10 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