K
Ksenya
Hi
I am working with a spreadsheet that was created by someone else, this is the forumla that is being used in the worksheet
=IF(ISBLANK('Raw Data'!$B9), "N/A", ('Raw Data'!B9)
I want to
Drag and Drop this formula in a column where column reference changes, i.e. B, C, D, E, F; but the row reference stays the same, i.e. B9. However, the exact oposite happends when i do this, column does not change, but the reference to the row does
Now, I 've tried drag and drop across the row, and the column reference doesn' changed, but the row reference stays contstant.
How can I solve this problem
Also, when I use cut and past of these formulas into the next column for some reason some of the cell references seem to jump all over the place. Example: I have a column
=IF(ISBLANK('Raw Data'!$B9), "N/A", ('Raw Data'!B9)
=IF(ISBLANK('Raw Data'!$C9), "N/A", ('Raw Data'!C9)
=IF(ISBLANK('Raw Data'!$D9), "N/A", ('Raw Data'!D9)
when I copy it over in the exact same order, but new column, it does things like
=IF(ISBLANK('Raw Data'!$B9), "N/A", ('Raw Data'!B9)
=IF(ISBLANK('Raw Data'!$E9), "N/A", ('Raw Data'!E9)
=IF(ISBLANK('Raw Data'!$J9), "N/A", ('Raw Data'!J9)
i.e. changes column reference
I would really appreciate any tips with this, right now i am doing what I can (i.e. like a total idiot sitting there and manually changing column reference in each cell
Thanks
K
I am working with a spreadsheet that was created by someone else, this is the forumla that is being used in the worksheet
=IF(ISBLANK('Raw Data'!$B9), "N/A", ('Raw Data'!B9)
I want to
Drag and Drop this formula in a column where column reference changes, i.e. B, C, D, E, F; but the row reference stays the same, i.e. B9. However, the exact oposite happends when i do this, column does not change, but the reference to the row does
Now, I 've tried drag and drop across the row, and the column reference doesn' changed, but the row reference stays contstant.
How can I solve this problem
Also, when I use cut and past of these formulas into the next column for some reason some of the cell references seem to jump all over the place. Example: I have a column
=IF(ISBLANK('Raw Data'!$B9), "N/A", ('Raw Data'!B9)
=IF(ISBLANK('Raw Data'!$C9), "N/A", ('Raw Data'!C9)
=IF(ISBLANK('Raw Data'!$D9), "N/A", ('Raw Data'!D9)
when I copy it over in the exact same order, but new column, it does things like
=IF(ISBLANK('Raw Data'!$B9), "N/A", ('Raw Data'!B9)
=IF(ISBLANK('Raw Data'!$E9), "N/A", ('Raw Data'!E9)
=IF(ISBLANK('Raw Data'!$J9), "N/A", ('Raw Data'!J9)
i.e. changes column reference
I would really appreciate any tips with this, right now i am doing what I can (i.e. like a total idiot sitting there and manually changing column reference in each cell
Thanks
K