Oct 03 2019 11:58 AM
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 the most in my data. What function do I use to do that. For example, in these rows Opportunity ID, Quote ID, SAP DMU, etc should be listed in a separate column 'Missing Values'.
Oct 03 2019 12:09 PM
@vakarithika I, on the top of my head, think of two solutions.
Alternatively, I wont be surprised if there is a way of doing this using pivots.
Oct 03 2019 01:00 PM
If you have access to the TEXTJOIN 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.