+ Reply to Thread
Results 1 to 4 of 4

Count and order

  1. #1
    Registered User
    Join Date
    05-29-2014
    MS-Off Ver
    2016
    Posts
    31

    Count and order

    If I want to achieve the following:
    In column 2, it is first time Jan appears, so it gives the number 1.
    In column 3, it is second time Jan appears, so it gives the number 2.
    In column 6, it is third time Jan appears, so it gives the number 3.
    In column 4, it is first time Feb appears, so it gives the number 1.
    In column 7, it is second time Feb appears, so it gives the number 2.
    and so on...
    which formula should I use in column C to achieve the above automatically?
    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,363

    Re: Count and order

    =COUNTIF($B$2:B2,B2)

    and copy down

  3. #3
    Registered User
    Join Date
    05-29-2014
    MS-Off Ver
    2016
    Posts
    31

    Re: Count and order

    Thanks.
    Works like a charm!

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,363

    Re: Count and order

    Glad to help.

+ 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. [SOLVED] How to count the order of occurrence of duplicates
    By orehovka in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-28-2023, 11:29 PM
  2. count if less than 5 & assign new numbering order
    By tabkaz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-02-2015, 03:31 PM
  3. [SOLVED] Formula to count duplicates in 1, 2, 3 order
    By kas05j in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2014, 11:02 AM
  4. [SOLVED] Count the value based on order
    By huy_le in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-05-2013, 10:33 PM
  5. Problem with 2 conditions in order to count
    By koncurn in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-30-2010, 12:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1