EE-Example.xlsx

Tom Crowfoot

<div>
<div class="content wysiwyg-content fr-view">
Hi Experts<br><br>In Excel need to be able to dynamically produce a list of users skipping blanks using a formula (something like a TEXTJOIN, but not all in one cell). &nbsp;I'm not sure if this makes a difference to the solution, but ...<br><br><ol><li>The data from which to produce the list is created by a complex IF formula &amp; hence the blanks in the data.</li><li>The list doesn't need any form of sorting</li></ol><br>I have attached a simple example with Column A being the data &amp; Column C being the end result. &nbsp;<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/07_w28/1565899/EE-Example.xlsx" rel="ugc">EE Example.xlsx</a>&nbsp;<br><br>Can anyone help?<br><br>
</div>
</div>



Hi Experts
In Excel need to be able to dynamically produce a list of users skipping blanks using a formula (something like a TEXTJOIN, but not all in one cell).  I'm not sure if this makes a difference to the solution, but ...
The data from which to produce the list is created by a complex IF formula & hence the blanks in the data.
The list doesn't need any form of sorting
I have attached a simple example with Column A being the data & Column C being the end result.  
EE Example.xlsx
 
Can anyone help?

Excel produce dynamic list skipping blanks

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.