How do i change my data file from 1' intervals to 5' intervals?
The way it is now The way I need it
8300 8300
8301 8305
8302 8310
8303
8304
8305
8306
8307
8308
8309
8310
thru 11,000
How do i change my data file from 1' intervals to 5' intervals?
The way it is now The way I need it
8300 8300
8301 8305
8302 8310
8303
8304
8305
8306
8307
8308
8309
8310
thru 11,000
This is how far i've gotten.
=OFFSET(Sheet1!$A$17,ROW()*5-1,0)
my sheet ranges from A17 thru I17 down to A3156 thru I3156.
Please help.
Last edited by VBA Noob; 07-10-2008 at 02:46 AM.
How does 8302 become 8310?
I think you need to explain what you're trying to do a little more clearly.
= 5* A1 - 33200
G'day and welcome to the forum,
Yes I'm not clear on how does 8302 becomes 8310.
There is one way, but it may not suit your goal.
Test this on a blank spreadsheet
Type in two separate cells
8300
8305
then highlight the two cells
then copy drag down
If this is what you want, apply it to your workbook.
Hope this helps
Have I made you happy ??? If yes, please make me happy by pressing the Add Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
I imported a data base into an excel file. The data base is incremental by 1. The person requesting this data would like it to be incremental by 5. Is there a formula that I can use to accomplish this? This is what I have so far.
=OFFSET(Sheet1!$A$17,ROW()*5-1,0) But its fairly incomplete.
Example: The way it is
A17 THRU I17
8300 data data data
8301
8302
8303
8304
8305 Thru 11,000 OR A3156 THRU I3156
Example: The way I need it
8300 data data data
8305
8310
Please help.
Threads merged. Is this intended to answer the same question you asked in http://excelforum.com/showthread.php?t=649361?
I imported a data base into an excel file. The data base is incremental by 1. The person requesting this data would like it to be incremental by 5. Is there a formula that I can use to accomplish this? This is what I have so far.
=OFFSET(Sheet1!$A$17,ROW()*5-1,0) But its fairly incomplete.
Example: The way it is
A17 THRU I17
8300 data data data
8301
8302
8303
8304
8305 Thru 11,000 OR A3156 THRU I3156
Example: The way I need it
8300 data data data
8305
8310
Please help.
well shg suggestion works for your example
= 5* A17 - 33200 works as long as the data starts at 8300
in your example
Does that helpPlease Login or Register to view this content.
Regards
Dav
Thanks that works to get my A column to display every 5th cell but my data ranges from A-I, and I need to display every 5th row, so how would I expand on this? =Sheet1!$A$15+(ROW(A1)-1)*5
Thanks Alot Dav I've Got It Figured Out
Jeff
Well I thought I had it, but I was wrong. I thought I could take this formula =Sheet1!$A$15+(ROW(A1)-1)*5 and substitute the A with B and then with C and so on, but it didn't work that way, I still need to convert the entire Range of data from A-I to display every 5th row.
Jeff
may be what you requirePlease Login or Register to view this content.
Does that help?
Regards
Dav
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks