Saturday night was fun with a part at colleague’s house. Then…,
You can also see all the 3 panels together here.
#awesome trick – Extract word by position using FILTERXML()
This is CRAZY!!!. I stumbled on a weird use for FILTERXML() while reading a forum post earlier today. So I couldn’t wait to test it. I am happy to share the results.
Say you have some text (sentence / phrase / keyword etc.) in a cell and you want to extract the nth word. Unfortunately Excel doesn’t have SPLIT() formula. So we end up writing obscenely long array formulas or use gazillion helper columns.
Here is the super sneaky trick. Use FILTERXML() instead.
3 Responses to “Powerpoint Cartoons #1”
Typical Jewish mother joke 🙂
Haha... you guys have fun!
Thankyou guys... 🙂