Here is a collection of Excel functions that I found to be very useful in certain situations.
- Convert report into data table
- Convert YYYYMMDD to date
- Count within groups – formula
- Create a group column based on existing values
- Filter bold text
- Football bet template
- Job satisfaction check
- Romanian Whist score keeper
- Subtotal on filtered data
- Team Holiday Planner
… adding as I find new stuff.