I have huge amount of data and I need to scatter plot every 20th cell, I was wondering how can I do it? I have (Plotting a graph with every nth cell) found here a solution by using the code =INDEX($A$4:$A$38,ROW(A1)*7) that someone suggested there but I have a little problem.
The first line I need to use is line 22, then after this line I need every 20th cell. can someone help me? I am a newbie in excel so I don't even know how to read this code right. all I did was to change it to =index($D$22:D25739,Row(D22)20
but it doesn't work...
thank you in advance
The first line I need to use is line 22, then after this line I need every 20th cell. can someone help me? I am a newbie in excel so I don't even know how to read this code right. all I did was to change it to =index($D$22:D25739,Row(D22)20
but it doesn't work...
thank you in advance