Using absolute functions "$" to populate a column from a row
Hi,
suppose the row data starts in B1 and you enter the following formula in A2
and copy down
=OFFSET($A$1,,ROW(A1))
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Repurr" wrote:
Hello,
Excel 2007
Is there anyway I can automatically populate a column from a row using "$"
Absolute functions in the formula, to save having to create a new formula to
poulate each column cell.
Thank for your help
--
Regards
Repurr
|