+ Reply to Thread
Results 1 to 6 of 6

Unknown Formula =[@[Duedate]]

Hybrid View

OM1950 Unknown Formula =[@[Duedate]] 12-06-2013, 05:25 PM
Norie It's a structured table... 12-06-2013, 05:27 PM
Tony Valko Re: Unknown Formula... 12-06-2013, 09:52 PM
OM1950 Re: Unknown Formula... 12-14-2013, 11:11 PM
Tony Valko Re: Unknown Formula... 12-14-2013, 11:23 PM
abousetta Re: Unknown Formula... 12-14-2013, 11:15 PM
  1. #1
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Unknown Formula =[@[Duedate]]

    Typically, you'd see something like this:

    =TableName[@[Due Date]]

    Where:

    TableName is the name of the table

    If no table name is present:

    =[@[Due Date]]

    That means the formula is in a cell that is within the table itself.

    The outer [ ] mean everything within them belongs to the table named TableName.

    The @ sign means "this row". If the formula is entered in cell X10 then it refers to the cell in the Due Date column on row 10.

    The inner [ ] refer to the column range headed by Due Date.

    If you want to see what the formulas look like in A1 reference style then:

    Select any cell within the table
    Right click>Table>Convert to range

    Select the cell that contains the formula. You might see something like this:

    =Sheet1!$B6

    Now, on the main menu bar click Undo to get the table reformatted back to a table!
    Last edited by Tony Valko; 12-06-2013 at 10:03 PM.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  2. #2
    Registered User
    Join Date
    11-29-2013
    Location
    Townsville, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Unknown Formula =[@[Duedate]]

    Thanks very much for this reply - it's obvious that I'm going to have to keep up with the new features in Excel !

    OM1950

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Unknown Formula =[@[Duedate]]

    You're welcome. Thanks for the feedback!

+ 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. Unknown Formula changes
    By izzynh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2012, 09:32 AM
  2. 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
  3. Duedate not working with cells with formulas
    By unley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2009, 08:51 PM
  4. Workbook call duedate more than one sheet
    By unley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2009, 08:05 PM
  5. [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