I've done a COUNTBLANK formula at the end of each column as I want to know the number of items missing/blank under each audit item.
The number of blanks shows with the formula, but I want to create a Pivot Table (or similar) to show how many of e.g. nationality / data of birth etc. is missing.
Thanks in advance
Test Audit - Summary of Blanks.xlsx
Bookmarks