I should have been more clear. I need just one increment. The issue is incrementing too many rows. I need it only to increment 1 row, as in the next row down the column, instead of incrementing the number of rows that I have skipped in the formula sheet.
I'm trying to duplicate a formula and skip rows, but pull data from one column with no rows skipped.
I have tried using the OFFSET() and INDIRECT() function but they seem to only do the opposite of what I need. I haven't tried these with $ though.
I need: (for a rough example)
B1=A1
B2=empty
B3=A2
Instead I get:
B1=A1
B2=empty
B3=A3
When I duplicate cell B1 into B3 (skipping a row) I get the reference skipped as well. This makes sense with the relative reference operation. I just want to get around to avoid skipping the references. So that B3=A2.
Please let me know if I'm even on the right track for this. If you have a moment, I appreciate you help very much.
Perhaps I can explain what I'm trying to with the data...let me know. I can send examples for more clarity.
Thanks
|