To copy links to another spreadsheet down a column. The info you are looking for is located in every other cell. ie F3, F5, F7. you want to fill the series (=$F3, =$F5, =$F7) automatically to save on typing. Fill series will do this with real numbers 3, 5, 7. Can it be down with a formula?
ANS
Put this in Row 1 of any column (besides F) and fill down
=INDIRECT("F" & 2*ROW()-1)
OR
Enter F3 & F5, then fill down via the fill handle (without the "="). You'll get F3, F5, F7, F9, etc. Select all, and edit/replace F with =F.
No comments:
Post a Comment