+ Reply to Thread
Results 1 to 3 of 3

Control numerical index based on check boxes

Hybrid View

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Control numerical index based on check boxes

    Here is an easy one. I have a large form that prints out to be about 10 pages long. Not all of the pages are used all the time, so I have a "Table of contents" at the top of the spreadsheet that uses check boxes to hide big groups of rows (pages) that are not required. What I would like to do is have page numbers next to each check box that stay in order regardless of what boxes are selected. If boxes 2, 4, 5, and 7 are checked, the numbers next to the boxes should be 1, 2, 3, and 4 respectively. I have attached a sample spreadsheet to illustrate what I am looking for. Thanks!

    Check box index example.xlsm

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Control numerical index based on check boxes

    Hello
    Perhaps the following formula copied down C3:C9:

    =IF(B3=TRUE,COUNTIF($B$3:B3,TRUE),"")
    Hope this helps.
    DBY
    Last edited by DBY; 10-18-2012 at 10:29 AM.

  3. #3
    Registered User
    Join Date
    10-15-2012
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Control numerical index based on check boxes

    That is excellent, thanks so much! I love this forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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