Sometimes you need to do what you need to do – use Regular Expressions for a trivial task. Now, imagine that you have some big text and you need to extract all substrings from the text between two specific words …
Python – Find All Substrings Between Two Character Pairs with RegEx Read more →
Reading from a pdf is actually quite an easy task with Python. If the PDF is of course “readable”, e.g. made from a word processor. The first thing to do is to install Tika and Java: pip install tika conda …
Ok, the title became too lengthy, but the idea is to try to duplicate the beauty of what this formula does: =INDEX(myTable[#All],MATCH(1, (myTable[[#All],[Profit]]=C9)* (myTable[[#All],[Currency]]=D9)* (myTable[[#All],[Value]]=B9),0),1) And this is the cell of the formula above: Anyway, the strange thing was that …
VBA – VLookup with Multiple Criteria in Excel without Excel Formula but with VBA Read more →