+ Reply to Thread
Results 1 to 4 of 4

Count and Number The Amount of Times That a Unique Value Appears in Increments of One

  1. #1
    Registered User
    Join Date
    07-24-2018
    Location
    New York, USA
    MS-Off Ver
    Office 2016
    Posts
    12

    Count and Number The Amount of Times That a Unique Value Appears in Increments of One

    Hi All,

    I'm facing a challenge in Excel that I can't seem to get my head around.

    I would need a formula that can look at how many times a value appears in a column and assign a numerical value that goes up by one for each time the value reappears.

    For example, if column A contains the value G01029 on five back-to-back rows, column B should give me values: 1,2,3,4,5. If column A contains the value G01030 twice, the corresponding result in column B for these values should be 1,2.

    I've attached a sample document. The real file contains about 20,000 rows of data.

    Your help is greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Count and Number The Amount of Times That a Unique Value Appears in Increments of One

    Use this formula in C2:

    =COUNTIF(A$2:A2,A2)

    then copy down.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    07-24-2018
    Location
    New York, USA
    MS-Off Ver
    Office 2016
    Posts
    12

    Re: Count and Number The Amount of Times That a Unique Value Appears in Increments of One

    Pete, the formula is working very well.
    Thank you very much for your help!!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Count and Number The Amount of Times That a Unique Value Appears in Increments of One

    You're welcome - glad to help.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ 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 the number of 15 minute increments between two times
    By shaun.burke in forum Excel General
    Replies: 3
    Last Post: 08-20-2019, 11:04 PM
  2. Replies: 4
    Last Post: 12-10-2014, 08:47 PM
  3. Replies: 2
    Last Post: 05-09-2013, 06:17 AM
  4. [SOLVED] Count the amount of times specific data appears based on criter
    By Ash Ford in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-11-2013, 12:19 PM
  5. [SOLVED] Count unique names only, not the number of times it appears
    By amyp22x3 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-04-2013, 01:32 PM
  6. [SOLVED] Count unique names only, not the number of times it appears
    By amyp22x3 in forum Excel General
    Replies: 7
    Last Post: 04-04-2013, 11:37 AM
  7. Replies: 2
    Last Post: 12-09-2009, 06: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