Forum Discussion
Extracting non-empty cells from a table based on a value
Hi,
There is an Excel table that we use to monitor reading compliance - columns are people names, rows are document codes, and cells are the reading dates.
Please find below a simplified vers...
Kaloyan,
is this what you had in mind?
| John Doe | Jane Doe | John Smith | Gandalf | |||
| THIS-123-V10 | 02.11.2017 | 05.10.2014 | John Doe, Gandalf | |||
| IS-456-V10 | 01.09.2017 | 01.09.2017 | Jane Doe, John Smith | |||
| A-789-V10 | 27.09.2017 | John Smith | ||||
| TEST-753-V10 | 02.11.2017 | 05.10.2014 | John Doe, Gandalf |
{=TEXTJOIN(", ",TRUE,IF(($B$2:$E$5)*($A$2:$A$5=A2),$B$1:$E$1,""))}
Detlef_Lewin did not get this to work in my 365 version.