Reference: forum discussion dated 17-18April2010

  • Thread starter Thread starter Andri
  • Start date Start date
A

Andri

Dear Ashish/Experts,
I have downloaded the addin from the below link.

thank you for your excellent External Excel Function, which is workable 100%.

but i have another issued, when the cells contains TEXT cells, the result is
little bit strange (without a comma).

here is the result:
CLOSEDCLOSED, it should be CLOSED, CLOSED
CLOSEDCANCEL, it should be CLOSED, CANCEL

please help and TIA.

respectfully,
andri
 
Andri,

Try this small change

=SUBSTITUTE(TRIM(MCONCAT(IF((($B$2:$B$11=B15)*($C$2:$C$11=C15)),TEXT(A2:A11,"dd/mm/yyyy"&" ")," ")))," ",", ")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Dear Mike,

Please guide further, nothing change.

the result still CLOSEDCLOSED, without the comma.

TIA.
 
Back
Top