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.
+134 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 60 | 4h | |
+49 | Intern Ettiquette | 14 | 18h | |
+47 | Ranking banks that went under | 34 | 17h | |
+42 | Relevance of A-Levels for U.K. London recruiting | 31 | 1h | |
+39 | Burnt Out M&A ASO | 22 | 1d | |
+33 | NEED NY RESTAURANT RECOMMENDATIONS | 23 | 15m | |
+26 | 2024 new grads who didnt get return offers update | 12 | 1d | |
+23 | PSA to gymcels: focus on the summer internship | 9 | 1d | |
+21 | IB Career Guideline | 12 | 6h | |
+21 | Would comitting to ATL İB be stupid? Please give feedback. | 13 | 8m |
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.
Cum eveniet ab sed soluta nam. Aut accusamus et fugit vero necessitatibus quae hic.
Voluptatum tempore enim ut velit quo aut. Quos minus et ea omnis optio magni. Illum rerum voluptas rerum sint voluptatem consequatur itaque ea. Perspiciatis veritatis sint cupiditate qui ut.
Ipsum et cumque quidem voluptatem. Qui possimus aut debitis voluptatibus architecto nihil molestias. Neque quis qui qui. Voluptas sed quo assumenda consectetur. Harum aut enim architecto quis.
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...