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 Hi, can i take this on my 2013 excel?i badly need it for my project.. if it cant make it to my excel then how this works in google sheet?i seldomly using that google sheet