+ Reply to Thread
Results 1 to 2 of 2

Running Numbers for Unique Values

  1. #1
    Registered User
    Join Date
    05-07-2011
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Running Numbers for Unique Values

    Hi,

    I want to have running number (wonder if it is the correct term) only for unique values.

    Attached is a sample of what I intend to do.

    I can do a
    Please Login or Register  to view this content.
    But it breaks when B2=A2, so I cannot simply drag the formula down.

    Can someone point me to a function that can help me achieve this?


    Thank you
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,949

    Re: Running Numbers for Unique Values

    I can follow that explanation. so, use this

    =IF(COUNTIF(B$4:B4,B4)=1,MAX(A$3:A3)+1,"")
    Attached Files Attached Files
    Glenn



+ 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. Formular to sum up the values for unique numbers in a column
    By chimezie123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2020, 09:44 PM
  2. Assign sequential numbers to unique values in a list
    By penfold in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-30-2017, 02:11 PM
  3. [SOLVED] Change numbers if unique values found
    By HaroonSid in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2017, 10:07 AM
  4. [SOLVED] running total of unique values
    By joannelittell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2013, 08:28 PM
  5. [SOLVED] Run-time error 1004 when running Advanced Filter for Unique Values in macro
    By jacobadger in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-17-2012, 02:17 PM
  6. [SOLVED] Countif unique values (only cells with numbers)
    By Davzx in forum Excel General
    Replies: 7
    Last Post: 06-27-2012, 12:39 PM
  7. Running count of multi-unique values
    By rz6657 in forum Excel General
    Replies: 1
    Last Post: 10-05-2010, 07:24 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