Consulting

Results 1 to 4 of 4

Thread: Interpretation of `@` sign in the formula bar

  1. #1

    Interpretation of `@` sign in the formula bar

    Hi,

    I am working with an Excel file, where I observed the use of '@' sign in the formula bar in some the cells.

    Attached is one such snapshot.
    Screen Shot 2021-11-22 at 13.11.51.jpg

    Is there any special meaning of the use of '@' in formula bar?

    Your pointer is highly appreciated.

  2. #2
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    3,916
    Location
    As I understand it, it is being used to indicate an implicit intersection operator. By that it returns a single value from the row which the formula current reside in. Please refer to the following https://support.microsoft.com/en-us/...e-c1c999be2b34
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    VBAX Sage
    Joined
    Apr 2007
    Posts
    8,092
    Location
    Quote Originally Posted by volabos View Post
    Hi,

    I am working with an Excel file, where I observed the use of '@' sign in the formula bar in some the cells.

    Attached is one such snapshot.

    Is there any special meaning of the use of '@' in formula bar?

    Your pointer is highly appreciated.

    The'@' at the beginning and the '#' sometimes at the end of a formula have to do with the new dynamic arrays


    The @ symbol precedes the reference and it forces Excel to treat the reference as it would have pre-dynamic arrays.


    The # symbol follows the reference and it makes it incredibly easy to refer to spilled ranges. You use the # after the reference to the cell in the top left corner of the spilled range.



    https://exceljet.net/glossary/dynami...ill%20range%22.

    https://exceljet.net/dynamic-array-formulas-in-excel

    https://a4accounting.com.au/new-form...mbol-in-excel/

    I made a sample WB when I was looking at dynamic arrays and some new formulas
    Attached Files Attached Files
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  4. #4
    This looks like a formula that is dividing Column8 by Column20 within a range formatted as table. The @ denotes we're taking the cell in column 8 viz 20 from the same row as where the formula is.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

Tags for this Thread

Posting Permissions

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