Results 1 to 7 of 7

Thread: =Scratch!A42

  1. #1
    Senior Member Bodarc's Avatar
    Join Date
    Aug 2013
    Location
    136 miles North of West
    Posts
    1,949


    Did you find this post helpful? Yes | No

    =Scratch!A42

    I saw the above Excel formula and can't find anything describing it. Do any of you know what this function is? What has to be in A42? The worksheet I saw it in was blank in the referenced cell but it still produced a value?
    Play within your bankroll, pick your games with care and learn everything you can about the game. The winning will come. It has to. It's in the cards. -- Bryce Carlson

  2. #2


    Did you find this post helpful? Yes | No
    Quote Originally Posted by Bodarc View Post
    I saw the above Excel formula and can't find anything describing it. Do any of you know what this function is? What has to be in A42? The worksheet I saw it in was blank in the referenced cell but it still produced a value?
    Does this help at all? http://exceluser.com/reports/invoice...ndex-match.htm

  3. #3
    Senior Member Bodarc's Avatar
    Join Date
    Aug 2013
    Location
    136 miles North of West
    Posts
    1,949


    Did you find this post helpful? Yes | No
    Don, I think that is a different kind of scratch. Here is a reference to Dr Jacobson's web page. About 1/3 down the page, you'll see a link called Twenty_One_Plus_Three_CA which opens up an excel spreadsheet. Look at cell C9 and you'll see what I mean. It references cell K26 which appears blank. I suppose he has a formula hidden from view. I just have never seen the formula =Scratch!.
    Play within your bankroll, pick your games with care and learn everything you can about the game. The winning will come. It has to. It's in the cards. -- Bryce Carlson

  4. #4


    Did you find this post helpful? Yes | No
    Pretty sure that "=Scratch!A42" refers to cell A42 on a sheet named Scratch, which may be hidden.

  5. #5
    Random number herder Norm's Avatar
    Join Date
    Dec 2011
    Location
    The mote in God's eye
    Posts
    12,461
    Blog Entries
    59


    Did you find this post helpful? Yes | No
    In the Home tab, click Format in the Cells Group. Click Hide and Unhide. This will tell you if there are hidden sheets. If it was hidden by a VBA macro, you probably can't unhide it this way.
    "I don't think outside the box; I think of what I can do with the box." - Henri Matisse

  6. #6
    Senior Member Bodarc's Avatar
    Join Date
    Aug 2013
    Location
    136 miles North of West
    Posts
    1,949


    Did you find this post helpful? Yes | No
    That's probably it Canceler, I didn't think about a hidden sheet. I was thinking of hidden formulas.

    Thanks
    Play within your bankroll, pick your games with care and learn everything you can about the game. The winning will come. It has to. It's in the cards. -- Bryce Carlson

  7. #7
    Senior Member Bodarc's Avatar
    Join Date
    Aug 2013
    Location
    136 miles North of West
    Posts
    1,949


    Did you find this post helpful? Yes | No
    Ahhh Thanks Norm. Just as you suspected Canceler. There was a sheet called Scratch that was hidden.
    Play within your bankroll, pick your games with care and learn everything you can about the game. The winning will come. It has to. It's in the cards. -- Bryce Carlson

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
  •  

About Blackjack: The Forum

BJTF is an advantage player site based on the principles of comity. That is, civil and considerate behavior for the mutual benefit of all involved. The goal of advantage play is the legal extraction of funds from gaming establishments by gaining a mathematic advantage and developing the skills required to use that advantage. To maximize our success, it is important to understand that we are all on the same side. Personal conflicts simply get in the way of our goals.