+ Reply to Thread
Results 1 to 5 of 5

Looking for duplicates and sequential numbering those

  1. #1
    Registered User
    Join Date
    08-17-2016
    Location
    Australia
    MS-Off Ver
    Office 365 Business
    Posts
    90

    Looking for duplicates and sequential numbering those

    The title is a mouthful but hear me out.

    I'm capturing people entering a venue. The individual's unique identifier is their phone number (column D).
    What I want to do is;
    look for the duplicates in column D,
    then look at column G and identify which time is earlier,
    with the result in column H - 1 for the first entry, 2 for the second entry. There will never be more than 2 entries per day.

    To be honest, I don't even know where to start with this one, but I want to avoid VBA.

    I've attached an example.


    Matt
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-17-2016
    Location
    Australia
    MS-Off Ver
    Office 365 Business
    Posts
    90

    Re: Looking for duplicates and sequential numbering those

    Solved it myself...=IF(COUNTIF($D$2:$D2, $D2)>1, "2", "1")

  3. #3
    Registered User
    Join Date
    08-17-2016
    Location
    Australia
    MS-Off Ver
    Office 365 Business
    Posts
    90

    Re: Looking for duplicates and sequential numbering those

    IT works for a single day but not for multiple days. Column I shows the result I'm searching for.
    Attached Files Attached Files

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Looking for duplicates and sequential numbering those

    Hope it helps:

    =MIN(2,COUNTIFS($D$2:$D2,$D2,$F$2:F2,F2))
    Quang PT

  5. #5
    Registered User
    Join Date
    08-17-2016
    Location
    Australia
    MS-Off Ver
    Office 365 Business
    Posts
    90

    Re: Looking for duplicates and sequential numbering those

    That'll do it! I wouldn't have worked that one out.

+ 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] [SOLVED] Sequential numbering of duplicates. COUNTIF but showing 1, 2, 3 etc.
    By Tigerlilygem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-30-2018, 01:12 PM
  2. [SOLVED] Sequential numbering
    By tpedry in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-08-2014, 01:15 PM
  3. Sequential numbering........................
    By N80RUL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2013, 10:58 PM
  4. Sequential numbering
    By taylorackley in forum Excel General
    Replies: 2
    Last Post: 08-26-2010, 02:19 PM
  5. Sequential numbering
    By antony moseley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2009, 09:49 AM
  6. Sequential numbering
    By EH003268 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-12-2007, 09:47 AM
  7. Sequential Numbering
    By Tom in forum Excel General
    Replies: 4
    Last Post: 08-21-2006, 05:25 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