I have a function that needs to grab data from 1 row at a time on another worksheet. However on the worksheet the function is on, I have extra spaces and dragging the function down causes it to iterate the number of those rows instead of one at a time.Picture:How do I get the behavior I want? I need to drag these functions down through ta few thousand rows, and would need it to iterate the row# on teh function automatically.
Dragging functions through multiple cells with spaces in Google Spreadsheets
google spreadsheets