Formulas, formulas, formulas – everyone’s favourite Excel topic. In this table I have identified a number of FAQs and I have put together a table to help you decide what feature to use when…
| Scenario | Formula/Function |
| Pull in missing data from somewhere else | Vlookup() or Index/Match or Xlookup() |
| Compare two lists | Vlookup() or Index/Match or Xlookup() using the Iferror function and Conditional formatting |
| Find the highest/lowest/average of a set of numbers | Max()/Min()/Average() |
| Assign a colour based on whether a condition is met | Conditional Formatting |
| Add up how many entries meet a number of conditions | Countifs()/Sumifs() |
| Use the same value over and over | Fix a cell/make it absolute |
| Summarize large amounts of data | Pivot tables |
| Create a chart | Try Recommended charts |
| Filter by colour | Filter by colour |
| Print a heading on every page | Print Titles |
| Identify and remove duplicates | Conditional Formatting and Data | Remove Duplicates |