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...
If you have access to the https://support.office.com/en-us/article/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c function, you could use something like:
=TEXTJOIN(", ",TRUE,IF(A2:T2="",$A$1:$T$1,""))which will return a comma separated list of the field names in each row in another column. Hope that helped.