Want to link from different workbook, into consecutive annual columns, when source is set up in monthly columns with annuals 12 apart.
Investment Banking Interview Course
- 7,548 questions across 469 investment banks. Crowdsourced from over 500,000 members.
- Technical, behavioral, networking, case videos, templates. All included.
- Most comprehensive IB interview course in the world.
Wall Street Oasis Notifications
Please tell us a little bit more about yourself to send you the most relevant notifications
Get Notified?
Popular Content See all
- Income Inequality, Is It UnavoidableIncome inequality, a topic that gets discussed a lot here. I've been reading up on it, namely books and a lot of articles. Would like to hear other's thoughts on it. My main thought is, would it be unavoidable? I feel there are two classes of people with money. Basically,...
- What Daily Habits Do You Have That Have Improved Your Life The Most?I've found that having a routine and doing certain things have made me much happier and more productive at work. It could be anything, for example things I do that I think would benefit everyone are: read, work out, listen to podcasts instead of music and journal. I'm trying to...
- What was your first big break?My first big break was back in freshman year, I managed to cold call the head of investment banking at X bank. Managed to impress him enough to say he would help in pushing my resume for an interview for that year's internship. But never got the internship nor interview for the summers...
- Is Western Civilization in decline?Just wanted to start a conversation as it's something I ponder almost every day and I'm sure many of you have valuable perspectives
- Effective LP oversight of GPFor deals that aren't going exactly as planned, what's an LP to do? I'm curious if anyone has examples of when LP's have had a positive influence on the ultimate outcome of a project, even if they were just pref equity and didn't have much legal standing in the operating...
- Nonlinear Career Tracks - Anyone on one? This post is for the nonlinear career trotters - All the paper perfect ivys to IB or Consulting can skip this thread unless you have some value to provide. But to the nonlinear career trotters, curious what your trajectories have looked like? Has anyone ever taking a job completely...
- AMA: Fundraising for Private Equity, Cap Intro & Investor Relations Career PathsGuys, Below is an AMA podcast + some key takeaways on fundraising for PE and HFs. I was in-house IR at a couple PE shops (1 successful, 2 not) and was head of cap intro at a BB ibank. What questions do you have for me? I'll do my best to cover / answer them all. WSO...
- AMA: Big 4 -> Military Officer -> Top 10 MBAHello! I’m new to the WSO community and received an email to do an AMA. I’ll be honest, I rarely open myself up to anyone in person, much less online. But, I do this in the spirit of paying it forward. Hopefully my journey can help others in this community. Brief background: BS...
- Books You RecommendWhat books do you recommend!? Name any of your top picks - finance related or not. * Venture Deals - Brad Feld (Great for VC) * Prince of Tides - Pat Conroy (literally nothing to do with finance just a great book- sad tho) * Straight to Hell by John Lefevre (stories from a...
- What Job Would You Do If You Weren't In Finance?I've been questioning my path recently. I'll be applying for full time positions soon and there's part of me that isn't 100% sold on what I am doing. It feels like it is the right path but I know there are so many other paths out there. For me, if I hadn't spent so...
Leaderboard See all
| 1 |  | 97.3 |
| 2 | | 97.3 |
| 3 | | 97.3 |
| 4 | | 97.2 |
| 5 | | 97.0 |
| 6 | | 96.9 |
| 7 | | 96.9 |
| 8 | | 96.8 |
| 9 | | 96.7 |
| 10 | | 96.7 |
Upcoming EventsSee all
- Jun15
- Jun18
- Jun19
- Jun19
- Jun19
Comments (9)
do offset(source,0,((column($A$1)-column(A$1))*12), this means that every time you drag it one cell right it will be grabbing 12 cells right in the source.
Appreciate it
Well, still having trouble when dragging to the right.
What's the problem? Might have to make this in to an indirect.
Oh snap, switch the 12 to -12, that'll give you the right number.
- IB Course
- | Suggested Resource
Learn More7,548 questions across 469 investment banks. The WSO Investment Banking Interview Prep Course has everything you'll ever need to start your career on Wall Street. Technical, Behavioral and Networking Courses + 2 Bonus Modules. Learn more.
When I drag it to the right it's just returning the next number over from the source. What should be my first number in there that you labeled "source"?
it should be the cell address of the first annual number you want to grab from the other sheet... a link to the #. then when you drag the formula right, for every cell to the right of that it should grab the next number in that other workbook 12 columns over..
What if I have semestral revenues, but I want to calculate yearly revenues in another tab.
I also need to drag a formula, but I couldn't find the right combination of offset.
It's basically the same exact problem as OP, but with two cells rather than 12.
Can someone help out?
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
Want to sign in with your social account?
Want to Vote on this Content?! No WSO Credits?
Join Us
Already a member? Login
Related Content
Popular Content
See all