Forum Discussion
How to insert formula into selected cell range (with static value)
Hi, is there any way to insert the same formula to a range of cells that already exist as static value (for example, insert the following "/@INDIRECT(ADDRESS(9,COLUMN()))" to selected cells that cont...
Paul_Y1225 What is the purpose of using the ADDRESS function?
When entered in, for instance, cell B20 the function ADDRESS(9,COLUMN()) will return a text like $B$9. Wrapping it in an INDIRECT function will return the value of cell B9.
Copying it down and across will return the values from row 9 for each column. The same can be achieved by entering =B$9 in B20 and copy down and across.