I’m sure many of you have built a spreadsheet like this before: you’ve got a table of data; one of the columns in this table contains a formula which references a span of columns in the same table. The number of columns you need to reference may change over time as requirements change. How do you you build this table in such a way that the number of columns can be changed without breaking the formula that references them? Let’s walk through a somewhat contrived but simple example to demonstrate the
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/04/08/a-robust-way-to-reference-multiple-columns-in-a-table.aspx
Posted
Apr 09 2009, 02:45 AM
by
Microsoft Excel