+ Reply to Thread
Results 1 to 4 of 4

Unknown Formula

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Unknown Formula

    Hi All,

    I have received a normal(xlsx) excel document, and it contains a formula that i cannot for the life of me figure out what it is doing. The formula is not know to excel and there is no visual basic function in the document. The formula is an array and looks like this {=TABLE(,C11)}. When i press F2 to enter the cell and then press ctl+shift+enter to submit the array it gives me an error, but if i press esc it accepts the function as it was previously. How can i figure out what the function is? I have to believe that the excel file has to be saving it somewhere, but i am not sure where. Any help is greatly appreciated.

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Unknown Formula

    Hi.

    It's due to a Data Table:

    http://www.excel-easy.com/examples/data-tables.html

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Unknown Formula

    Thank you very much!

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Unknown Formula

    You're welcome!

    Cheers

+ 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. VBA: 2 open workbooks; 1 unknown; activating the unknown one
    By Janis Rainis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-05-2014, 08:46 AM
  2. [SOLVED] Unknown Formula =[@[Duedate]]
    By OM1950 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-14-2013, 11:23 PM
  3. Unknown Formula changes
    By izzynh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2012, 09:32 AM
  4. if, then formula help for an unknown number
    By flopped.quads00 in forum Excel General
    Replies: 5
    Last Post: 01-06-2012, 11:44 PM
  5. Change Formula for unknown last Row
    By realniceguy5000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2011, 08:12 AM
  6. Summing across unknown range in unknown cell!
    By agentred in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 10-28-2009, 10:10 AM
  7. Percentage Formula Unknown. Plz Help!!!
    By Studpuppy21 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2007, 11:38 AM
  8. [SOLVED] Unknown Formula
    By Lucky_guy2000 in forum Excel General
    Replies: 4
    Last Post: 04-28-2006, 11:25 AM

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