Reference used in formula

[rsinclair]

I saw the following reference being used in a formula and I'm unable to figure out what it means or how to use it. Can anyone help?

Reference: =[@[Column_Header]]

I am not sure what the square brackets or @ is for. Would really appreciate some help understanding this one.

Kind Regards,
RSinclair

 

[Smitty]

Welcome to the Board!

That's a Data Table formula. You'll find a good introduction to them here: http://www.jkp-ads.com/articles/Excel2007Tables.asp

HTH,

 

[T. Valko]

I saw the following reference being used in a formula and I'm unable to figure out what it means or how to use it. Can anyone help?

Reference: =[@[Column_Header]]

I am not sure what the square brackets or @ is for. Would really appreciate some help understanding this one.

Kind Regards,
RSinclair

It's called structured referencing.

Excel 2007:

http://office.microsoft.com/en-gb/e...references-with-excel-tables-HA010155686.aspx

Excel 2010:

http://office.microsoft.com/en-us/e...references-with-excel-tables-HA010342999.aspx

Describes the use of the new @ sign:

http://blogs.msdn.com/b/excel/archive/2010/01/25/table-improvements-in-excel-2010.aspx

Personally, I hate it!

 

[rsinclair]

Thanks guys...I really appreciate the help.

Regards,
RSinclair

 

[Smitty]

Personally, I hate it!

Ditto, although you do get some nice formatting options.