+ Reply to Thread
Results 1 to 3 of 3

Dynamic numbering

  1. #1
    Registered User
    Join Date
    09-14-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    82

    Dynamic numbering

    Hi, I'm trying to create dynamic numbering for headers in an Excel model. The file attached has a Header and then two types of sub-header. The number for the headers is 1, 2, 3, etc... Numbering for the sub-headers is then 1.1, 1.2, 2.1, 2.2 etc... Finally I also have a 3rd sub-header which would read 1.11, 1.12, 2.11, 2.12 etc...
    I simply want to be able to copy and paste the formula, which will calculate what the header number should be.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor PaulSP8's Avatar
    Join Date
    11-21-2017
    Location
    Chorley, England
    MS-Off Ver
    2013 & 2021
    Posts
    437

    Re: Dynamic numbering

    Like this?

    In B3;

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    In C4;

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by PaulSP8; 12-13-2018 at 10:55 AM.

  3. #3
    Registered User
    Join Date
    09-14-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    82

    Re: Dynamic numbering

    That's a fantastic formula - thank you

+ 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. Multi level reference id - auto numbering - similar to legal numbering
    By smsko in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-11-2017, 06:05 AM
  2. [SOLVED] Dynamic formula for specific numbering order
    By JO505 in forum Excel General
    Replies: 14
    Last Post: 03-07-2015, 01:13 AM
  3. [SOLVED] Row Numbering with dynamic formula
    By KMCurtis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2014, 01:20 PM
  4. Replies: 2
    Last Post: 06-27-2014, 06:40 AM
  5. [SOLVED] Dynamic numbering formula with an If condition
    By Oceans in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 11-06-2013, 02:58 PM
  6. Contractable/Expandable Dynamic Numbering Formula
    By aleo1203 in forum Excel General
    Replies: 4
    Last Post: 01-28-2011, 11:43 AM
  7. WBS numbering help, auto numbering with indenture
    By hisham2929 in forum Excel General
    Replies: 2
    Last Post: 02-18-2007, 06:59 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