I have data in sheet 1 that I need to the data for every third row, starting at A4,
So, A4, A7, A10...
into column A on sheet 2 with a simple formula that I can copy & paste down starting at A2 in sheet 2.
I need to avoid macros bc I am not well enough versed in them at this point.
I have tried the offset function which other people said has worked but it will not for me, here is what I have typed so far.
In Sheet2 A2 I have the following function typed
=OFFSET(Sheet1!A4,(ROW(A1)-1)*3,0)
This gives me the correct data that I want from sheet 1 A4
But then when I drag the function down it does not give back the values I want at all.
I know I probably have something wrong with the offset function, as I keep trying to adjust it but keep getting more & more confused.
Any help would be greatly appreciated.
Thanks!
Bookmarks