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.
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 [Code].... [/Code] 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
Originally Posted by volabos
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
---------------------------------------------------------------------------------------------------------------------
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
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.
Reply With Quote
