Excel formula generation

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I have data spaced 264 rows apart that I need to extract from a massive mess of data. Basically, I need to tell excel to pick info from cell =C2 then cell =C266, then =C530, going down the columns I have..basically to about row C80000. This is going to be exceedingly tedious to do by hand with over 300 pieces of data I need to extract unless Excel knows to space 264 columns at a time. Is there any way I can tell Excel to skip the interim 264 rows as I create my condensed data table? If I could base the cell position off a formula, that would work wonderfully. (C[2+264*1], C[2+264*2], etc.


2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can try like this

For C=2 to 80000 Step 256

Cvalue = Cells(C, "C")
Next C
In a macro?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Yes. In a macro

I am not sure how would you do so in formula. I dont say that is not possible, but it would be hard. Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ ,https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too