Two things make Google Sheets infinitely more useful than Excel to me on a daily basis:
- Regex support in find & replace and regexextract().
- FX rates as a formula instead of as a data type. IIRC Excel requires 2 columns to display a FX rate (one to specify the pair, one to print the number); Google Sheets specifies the pair inside the formula.
- Regex support in find & replace and regexextract(). - FX rates as a formula instead of as a data type. IIRC Excel requires 2 columns to display a FX rate (one to specify the pair, one to print the number); Google Sheets specifies the pair inside the formula.