22
3
I've seen someone construct what seemed like cell references in Excel that looked like
=[@[column title]]*someothercell
What is this feature called, are the rectangular brackets and the at sign independent or do they belong together? How does it work precisely?
I've googled around for a while and tried by hand in Excel, but couldn't get it to work.
2@Indrek I'm working with Excel 2013 and omitting the
@
seems to still work - do you know what exactly is the difference between[@somecol]
and[somecol]
? – eddi – 2015-05-12T18:14:34.3073Very old thread but in case it's useful... The @symbol is used to select the current row, omitting this will select all rows in that column. This is only apparent when using aggregate such as sum, average etc. so
=AVERAGE([@MyDataColumn])
would just the return the same value present in MyDataColumn but=AVERAGE([MyDataColumn])
would return the average of the entire column – Alan Schofield – 2017-06-29T18:34:27.0731Great, thanks for your help!! Using your link at a starting point, I was able to figure out the rest - hope it is okay I edited it into your answer to be able to give you the green checkmark :-). – Jonas Heidelberg – 2012-11-07T10:54:27.630
@JonasHeidelberg No problem, thanks for contributing! – Indrek – 2012-11-07T11:57:47.650