Printable View
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.
Attachment 29180
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
Quote:
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
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.