Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Setting up a check box

    I would like to set up a check check box in Col A, which is in the column next to the account numbers to ensure that all the account numbers have been mapped i.e being taken into account. A trial balance is imported into my management accounts workbook each month and if any new account numbers have been added, I will be able to pick this up immediately by having a check box to see if there are any new account numbers

    Your assistance in setting this up is most appreciated
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Why a check box? Why not just add an "x" into the cell in column A?

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Good idea Steve.

    Each time new data is imported how would I keep track if what is existing account numbers what is new account numbrrs afterthe account numbers are imported

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If you import starting in Row 114 (for example) you could add in A114 the formula:
    =ISNUMBER(MATCH(B114,$B$1:$B$113,0))

    It will list TRUE if the value in B114 exists in the previous values and FALSE if it does not.

    Steve

  5. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Steve

    Thanks for the help. I'm not sure if the ISNUMBER(Match formula will work in this instance

    I have attached some sample data. The imported account numbers are in Col EI and the existing account numbers are in Col E

    I want to compare the new numbers to the existing numbers and to identify which numbers are unique i.e which new numbers have been added to Col EI

    Your assistance in this regard is most appreciated
    Attached Files Attached Files

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Why not just do a match and insert an "x"? =IF(ISERROR(MATCH(E12,EI:EI,0)),"","x")

  7. #7
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Thanks for the help, much appreciated.
    Last edited by HowardC; 2012-08-12 at 13:26.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •