Offset Vs. Choose functions
Ok excel junkies, can I get a definitive argument for why you would use the "OFFSET" function and why you would use the "CHOOSE" function?
Thanks.
Ok excel junkies, can I get a definitive argument for why you would use the "OFFSET" function and why you would use the "CHOOSE" function?
Thanks.
+165 | How to stop feeling like shit for not making it in IB? | 61 | 22m | |
+121 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 59 | 5h | |
+85 | Updated LA Banking Scene (2024) | 61 | 1h | |
+40 | Ranking banks that went under | 24 | 2h | |
+38 | Burnt Out M&A ASO | 20 | 1h | |
+36 | Relevance of A-Levels for U.K. London recruiting | 25 | 13m | |
+33 | A strategy for SA applicants late to the game like myself | 17 | 2s | |
+27 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
+27 | Intern Ettiquette | 4 | 1d | |
+26 | How to overcome Sexual Attraction to PJT? | 8 | 2h |
Career Resources
Haven't used choose in 4 years and I'm doing fine.
Offset is great, you can add as many cases as you want by shift+space+alt+i+r and then start typing new assumptions and it won't take you hours.
Why would you press Shift + Space first? You can just press Alt + I + R to insert a row...
This isn't a fully comprehensive answer, just consider it an example of why you might choose one over the other (no pun intended). Let's say you are trying to run different scenarios in your analysis -- this can be as simple as choosing 1 of 3 different revenue cases. In a simple example like this, one may be inclined to use the CHOOSE function since there isn't a huge variety of cases to run and you are only switching one thing. You're only referencing 4 cells in the formula (the index number and 3 cells corresponding to each case value) which isn't too much of a pain setting up before you copy across. I have also heard that some less Excel-savvy senior guys who sometimes find themselves in the model may find CHOOSE functions a little more friendly.
A simple example of using one versus the other may help you see how CHOOSE can appear to be more straightforward or easy to understand than OFFSET. I am not sure what your experience with Excel is, but I am happy to PM you a few examples of applying each of to show you some of their various uses I frequently come across in IB excel work.
In one case you are using an index number to select a particular cell from a specific permutation. In the other you are using either one or two numbers to determine how/where to travel from an inputted reference cell, where that reference cell also has flexibility that you can control as you move the formula across cells. Obviously one formula is far more flexible than the other, allowing for some more creative applications. However, depending on what you need, you may forego the elegance of OFFSET and keep things simple and straightforward with CHOOSE.
Once I learned Index/Match I've never looked back. Most pliable thing out there - that I've come across at least.
Offset and choose are totally different. Offset lets you travel rows and columns, but more importantly, lets you output a 2-d array to be used within another formula/function. Choose just lets you select from a list of values based on a specified position within that list.
Choose blows.
If you anticipate knowing exactly how many cases you're going to run, then fine use chose but given that every model every has scenarios that require you to flex different aspects with new scenarios constantly being added, offset is infinitely better.
I would personally use OFFSET only as last resort, since you cant track its inputs through tracking formula dependent.
I have never used Choose lol.. Which is sad considering everything I do in Excel. I personally do Offsets or you can do Index, Hlookup, etc
To quote one of my current favorite movies, "there are many answers to the question sir, but only one right answer."
Offset.
Vel cum labore minus aut eos. Exercitationem nam dolor eos voluptate architecto vero maiores. Quo ipsum quibusdam nam nostrum sed omnis magnam. Repudiandae culpa aut molestiae rem accusamus minus. Et delectus dolores tempora beatae.
Inventore reprehenderit eos rerum. Eveniet omnis ut ex autem occaecati adipisci magni. Voluptatum sunt magnam est. Temporibus enim nobis quidem vero saepe eum omnis.
Et ut enim eligendi in delectus rerum ratione. Quisquam temporibus ut quod quia consequatur quasi.
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)
or Unlock with your social account...