Hi People,
I hope you all are doing well and staying safe. I've a question for you folks.
I am trying to copy paste values from sheet 1 to sheet 2 after a specific interval. For example A1, A15, A29, A43 ... so on in another sheet in cells A1, A2, A3, A4 etc..
Attaching a sample for you as well.
Can you help me with a formula.
Thank you very much in advance.
Best,
Varun
Is what you are really trying to do is find all the values in sheet1 that are greater than 0 or are you simply trying to reproduce what you have in sheet2, because those are two different formulas?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Put this formula in cell A2 of Sheet2:
=INDEX(Sheet1!A:A,(ROWS($1:1)-1)*13+2)
then drag down as required.
Hope this helps.
Pete
Hi, I am trying to reproduce what I have in Sheet2. I may have values greater than 0 in my actual data.
Thank you for replying to my query
In case you do not understand the significance of the "2" in Pete's formula, you may prefer this, virtually identical, version. Both deliver EXACTLY the same result...
=INDEX(Sheet1!$A$2:$A$1000,1+13*(ROWS($1:1)-1))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Perhaps you didn't see my formula, as you posted very soon after my post.
Pete
you guys are gr8!! thank you very very much both of you for your quick revert. Really really appreciable.
Glad to help - thanks for the rep.
Please use Thread Tools in the menu above your first post to mark the thread as Solved.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks