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...
Hi Detlef,
I'm using 2010 :) TEXTJOIN is a 2016-only formula unfortunately
In general this could be an option if it worked for me. I need to have the formula on a separate sheet, but this is something that's easily adjustable.
I was imaging it that it would read code from a editable cell and then return different names in separate cells, but I'm not convinced if it can be achieved.
Is there a formula that could work in Office 2010?
Thanks
I'm using 2010 :) TEXTJOIN is a 2016-only formula unfortunately
In general this could be an option if it worked for me. I need to have the formula on a separate sheet, but this is something that's easily adjustable.
I was imaging it that it would read code from a editable cell and then return different names in separate cells, but I'm not convinced if it can be achieved.
Is there a formula that could work in Office 2010?
Thanks
Kaloyan,
a formula solution would need as many helper columns as your original data. And it would be an array formula - something like Willy's solution.