Tag Archives: formula

Short memo on COUNTIFS(), SUMIFS() and VLOOKUP() functions in MS Excel

Not using Excel very often, I sometimes have to waste my time searching Office support site for these functions in order to refresh in memory their tricky syntax and usage limitations. Today I decided to gather everything I know about … Continue reading

Posted in Tips & tricks | Tagged , , , , , | Leave a comment

Excel formulas syntax

Once, I thought embedding SQL requests into a code was the most boring thing I could imagine. Now I’m losing all my marbles while trying to push MS Excel formulas into my Python script.

Posted in Impressions, IRL | Tagged , , , | Leave a comment