Excel formula generation

Closed
Furbie - Jun 21, 2010 at 02:59 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 22, 2010 at 07:19 PM
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.


Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 21, 2010 at 06:04 PM
you can try like this

For C=2 to 80000 Step 256

Cvalue = Cells(C, "C")
Next C
In a macro?
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 22, 2010 at 07:19 PM
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
0