This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I have a table that has missing/ empty cells in rows that I want to identify the column headings that have the missing cells.
I have used the formula =ARRAYFORMULA(TEXTJOIN(", ",1,IF((E8:DO8="",E$5:DO$5,)))
If just provides an error saying #NAME?
I have also tried just TEXTJOIN without the ARRAYFORMULA and it then gives me lots of 0's?
I have also used Shift+Control+Enter
The Picture below shows the headings in row 5, and in E8 is where the names start, I put the array formula column at the end of the table.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
ARRAYFORMULA is a Google Sheets function. If you are using Excel, remove that.
Hi,
Why are there 2 ( after IF. Remove one and also the last one. Remove the last comma as well.
I don't really see how your formula references relate to your image? Row 8 appears to be part of merged cells in all those columns. Also, your formula as posted is actually invalid.
My guess is that you merged the cells, and that is why you are getting 0's. There is no longer a cell E5, ...etc
Thanks Rory,
I have removed it and just used =TEXTJOIN(", ",1,IF((E8:DO8="",E$5:DO$5,)))
And I just get a bunch of 0's and not the column headings?