Xavier Olive research teaching python blog til cli

Finding my way around Excel functions

6 December 2021

I am really not a big fan of Excel but there are situations where I cannot avoid it. It becomes very frustrating to not be able to program all what I could do with Python/Pandas.

Today, I managed my way around with functions found on this website: my use cases revolved around:

  • concatenating strings with the & operator;
  • finding a line matching a regexp in a different sheet with MATCH;
  • build up the string for a cell reference with INDIRECT.