When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

There’s a fix, and it’s simpler than you might think. My Online Training Hub uncover the one thing Excel tables consistently get wrong: their inability to reliably lock column references.

Learn how to prevent costly Excel errors with our comprehensive formula checklist. Ensure accuracy and reliability in your spreadsheets ...

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.