Login

u/Downtown-Economics26

r/BookCollecting r/excel
Image 1 — Victor Hugo English Language First Editions & Miscellaneous Aldine/Antiquarian
Image 2 — Victor Hugo English Language First Editions & Miscellaneous Aldine/Antiquarian
Image 3 — Victor Hugo English Language First Editions & Miscellaneous Aldine/Antiquarian
Image 4 — Victor Hugo English Language First Editions & Miscellaneous Aldine/Antiquarian
▲ 35 r/BookCollecting

Victor Hugo English Language First Editions & Miscellaneous Aldine/Antiquarian

Almost no one else I know, including my wife, is interested in my book collection so I figured why not share it here.

Spent 10+ years getting first English language editions of Hugo's novels, some American and some British... not 100% sure every single one is a "true" first because doing research is hard.

Also have 2 Aldines, one is 1 of 3 volume Cicero edition from 1552 as well as 1516 edition of Ovid's Metamorphoses. I can't read Latin (or Greek) nor can I afford to really collect Aldines but I love the history. The Ovid, Hunchback, and 5 vol Les Mis are all fairly valuable, the rest are minimally or somewhat but not immensely valuable (hundreds not thousands of dollars).

u/Downtown-Economics26 — 25 days ago
▲ 119 r/excel

All You Need Is SWITCH

I don't think I've seen this discussed before, so I apologize if I am rehashing old material. I did a cursory search and found nothing.

For a decade now, I've argued you should always use COUNT/SUM/MAX/MINIFS instead of COUNTIF because you never know when you'll need additional conditions. In present times, we don't even need COUNTIFS/RACON functions because you can do the same thing with array formulas although COUNTIFS is easier to type, IMO.

So when a week or two ago I learned you can do the same thing as IFS with SWITCH. This got me to thinking... based on the COUNTIFS principle I'm whimsically calling "the condition of sufficient conditions is always conditional"... I'm thinking the meta is to always use SWITCH instead of IF or IFS. This would be a very hard habit to form as I've used more IF statements than Diddy used bottles of baby oil, but let's be aspirational.

https://preview.redd.it/n530f9gwzx0h1.png?width=888&format=png&auto=webp&s=1b63482b3d9562bb0dfaa80fc05851beeecc819b

Now, the SWITCH version of your basic Hot Dog/Not Hot Dog IF is I think the same amount keystrokes (with tab completion), so I'm calling that a win. I'll grant that the IFS version of multiple logical operators is more "straightforward" or even "intuitive" if you're reading an online tutorial on multi-conditionals, but if you want one function-ring to rule them all and in the darkness gut em like a fish, then ALL YOU NEED IS SWITCH.

=SWITCH(A1,"Hot Dog","Hot Dog","Not Hot Dog")

=IF(A1="Hot Dog","Hot Dog","Not Hot Dog")

Now, being a rational being, let's consider the downsides.

  • Backwards Compatibility / No One Understands What The Hell You Are Doing
    • Backwards compatibility needs are typically a foreseeable binary so... whatever, my condolences if you don't get to live in 365 function utopia.
    • If you need other people to understand what you are doing this may be a bad habit to form.
  • File Size Bloat Cuz You've Become A SWITCHaholic
    • You keep adding conditions and dragging down formulas because you've committed to an absolutist and universalist vision of SWITCH as the one true function and forgot that after 3 conditions for sure you should just make a lookup table and only store the reference data once.

Anyways, interested to hear anyone else's thoughts even if you just tell me this is the ramblings of a mad man.

Edit for posterity:

Additional Significant Downside(s)

reddit.com
u/Downtown-Economics26 — 28 days ago