You are reading a single comment by @NotThamesWater and its replies. Click here to read the full conversation.
  • Using the audit functions. Because you'll probably be unravelling the mess left by the previous Excel person.

    Knowledge of function flags like 0 or 1 in vlookup, or -1, 0, 1 in match.

    Different VBA functions available between different versions of Excel.

    If they wanted an Excel god, they would have specified they need an Excel MVP.

About