+ Reply to Thread
Results 1 to 6 of 6

Looking for some Sequence numbering help

  1. #1
    Registered User
    Join Date
    01-23-2019
    Location
    toronto
    MS-Off Ver
    2010
    Posts
    42

    Looking for some Sequence numbering help

    Hi
    I need help with creating a formula that will number items sequential and also repetitively

    Col A: this is the # of cheques
    Col B: This is the Invoices in each Cheques ( So basically 1 cheque can have multiple invoices)
    Col C & D: these are the columns i need formulas for, I want Col C to automatically number the cheques and i want D to number the invoices in each cheque and the start again from 1 when it is counting a new invoice.
    So for example in the table below Cheque "test 130" is 1 cheque with 2 invoices so Col C2 and C3 would be "1", while col D2 =1 and D3=2, ( which represents the 2 invoices in that one cheque
    Any help with the formula would be greatly appreciated

    Untitled picture.png

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,908

    Re: Looking for some Sequence numbering help

    Try this in C2:

    =IF(A2=A1,C1,N(C1)+1)

    in D2:

    =COUNTIFS($A$2:A2,A2,$C$2:C2,C2)

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Looking for some Sequence numbering help

    @ Phuocam

    Wouldn't =COUNTIF($A$2:A2,A2) suffice?

    Or am I missing a detail?

    Dave
    Dave

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,908

    Re: Looking for some Sequence numbering help

    @ FlameRetired,

    Yes! It is simpler than I thought .

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Looking for some Sequence numbering help

    Glad to help. Thank you for the added rep.

  6. #6
    Registered User
    Join Date
    01-23-2019
    Location
    toronto
    MS-Off Ver
    2010
    Posts
    42

    Re: Looking for some Sequence numbering help

    Thank you both so much it worked

+ 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] numbering sequence code
    By RJ1969 in forum Excel General
    Replies: 15
    Last Post: 10-21-2018, 06:00 PM
  2. Sequence Numbering
    By thong127 in forum Excel General
    Replies: 4
    Last Post: 11-15-2016, 01:18 PM
  3. sequence numbering
    By jparmar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2016, 09:11 AM
  4. [SOLVED] Sequence in numbering..
    By Exequiel3k in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-26-2016, 10:58 AM
  5. Sequence numbering for each duplicate record
    By excel.help in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2011, 05:48 PM
  6. Numbering a sequence
    By nods in forum Excel General
    Replies: 4
    Last Post: 10-06-2010, 11:00 AM
  7. Numbering Sequence
    By scw1217 in forum Excel General
    Replies: 1
    Last Post: 02-23-2009, 05:51 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