Forum Discussion
Find and list missing fields in Excel row
I have a spreadsheet with a bunch of columns I am trying to populate over time. I want to have a column listing all the column values in each row that are missing so I can see what is missing t...
vakarithika I, on the top of my head, think of two solutions.
- If the number of columns and the format of the sheet are going to remain static, you can always have a formula check for empty columns and concatenate the column names to give you that calculated field value.
- A VBA macro. How I love macros! Its more dynamic in nature and can dynamically calculate based on number of columns and rows.
Alternatively, I wont be surprised if there is a way of doing this using pivots.