You could use a formula
Say your data begins A2
In B2
In B3
=A2
Drag/Fill Down=IF(INDEX(A:A,(ROW(A1)*25)+ROW($A$2),1)="","",INDEX(A:A,(ROW(A1)*25)+ROW($A$2),1))
You could use, instead of ROW($A$2), just 2
I just used ROW($A$2) to illustrate that we are adding the start row as an "offset" for the returned values.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
watersev
When I try to download your file, I get a [Microsoft Visual Basic - File not Found] error message, twice; and then another error message regarding 'unreadable contents'.
But I would really like to see your proposed approach!
Marcol
I understand your approach, but the data extends beyond one column.
For example, I just opened the file from one of this morning's tests.
The data to plot for three of the spreadsheets extends from columns A through N (for all three sheets), and the number of rows are 54005, 67992, and 41449.
Thanks for following up!
Alex
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks