How can I return numerous matches into one cell and separate by CHAR(10)?
In B1:K1 I have: Trn1, Trn2 thru Trn10
In A2:A11 I have: Name1, Name2 thru Name10
There is a 1 in in each cell where the person has NOT completed a Trn item.
I want to return ALL the training items not completed into one cell for each Name and use CHAR(10) to force a carriage return after each not trained item...
Hope that make sense.
In B1:K1 I have: Trn1, Trn2 thru Trn10
In A2:A11 I have: Name1, Name2 thru Name10
There is a 1 in in each cell where the person has NOT completed a Trn item.
I want to return ALL the training items not completed into one cell for each Name and use CHAR(10) to force a carriage return after each not trained item...
Hope that make sense.