Hi,
I am trying to link the cells up in a new workbook the problem is the data I need is setup in a way the formula needs to skip every other row.
For example:
When I drag this the next cell down is "C70"
Please Login or Register to view this content.
However I need the formula to be C71 and so on down to C137
How can you drag a formula yet skip every other row?
Any Idea's?
Thank You, Mike
Last edited by realniceguy5000; 05-11-2009 at 11:19 AM.
For sake of example let's assume:
A1: ='[New Totals.xls] Totals'!$C69
A2: ='[New Totals.xls] Totals'!$C71
to achieve the above output using a dragged formula from A1
A1: =INDEX('[New Totals.xls] Totals'!$C$69:$C$1000,1+(2*(ROWS(A$1:A1)-1)))
drage down ... adjust ranges to suit
Last edited by DonkeyOte; 05-11-2009 at 11:04 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks!!! I have no idea how that works but it appears to be working just fine...Originally Posted by DonkeyOte
Thanks Again for your help!!!
Mike
Thank you so much DonkeyOat with a little tweaking you have given my the formula to solve a pain every second date reference I have had for weeks thank you soooo much!!
I'm trying to do the opposite as this. On one page I have a list of dates that I'm trying to copy to a different work page.
Where I'm putting the results there are titles on every second row and every third row is hidden.
Ex:
A5= '% Solids'!A2
A8= '% Solids'!A3
A11='% Solids'!A4
and so on
how would the formula work for that?
devonlabelle,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ben Van Johnson
Thanks very much for posting this!
I registered an account for the sole purpose of providing the following feedback:
This is not a bad policy, but the way you've applied it here is. The follow-up question was 100% relevant to the original question, and was the same question I had that caused Google to lead me to this discussion. I can't describe the level of irritation your response caused. Your action does not foster the exchange of relevant information but rather impedes it. I hope feedback like mine causes you to rethink such a pointlessly and detrimentally rigid approach to discussion in the future. Feel free to delete my account - I only created it for you.
I am using index formula to represent horizontal data into vertical one. And the balance is updated every week skipping three rows. How can i use the formula to show the latest figures automatically?
Capture.PNG
harryxmin,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Did you ever find a solution to this?
I don't want to read through 11 posts to try to figure out what you want. Please start your own thread. ALSO...
Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution is also shown (mock up the results manually).
3. Make sure that all confidential information is removed first!!
4. Try to avoid using merged cells. They cause lots of problems!
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks