Reference: forum discussion dated 17-18April2010
in [Functions]
|
From: Andri on 24 Apr 2010 03:16 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 "Ashish Mathur" wrote: > Hi, > > Download and install the following addin - > http://www.download.com/Morefunc/3000-2077_4-10423159.html and then use the > following array formula > > =SUBSTITUTE(TRIM(MCONCAT(IF((($B$2:$B$11=B15)*($C$2:$C$11=C15)),TEXT(A2:A11,"dd/mm/yyyy")," > ")))," ",", ") > > B15 has A and C15 has N > > -- > Regards, > > Ashish Mathur > Microsoft Excel MVP > www.ashishmathur.com
From: Mike H on 24 Apr 2010 05:48 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. "Andri" wrote: > > > 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 > > "Ashish Mathur" wrote: > > > Hi, > > > > Download and install the following addin - > > http://www.download.com/Morefunc/3000-2077_4-10423159.html and then use the > > following array formula > > > > =SUBSTITUTE(TRIM(MCONCAT(IF((($B$2:$B$11=B15)*($C$2:$C$11=C15)),TEXT(A2:A11,"dd/mm/yyyy")," > > ")))," ",", ") > > > > B15 has A and C15 has N > > > > -- > > Regards, > > > > Ashish Mathur > > Microsoft Excel MVP > > www.ashishmathur.com >
From: Andri on 24 Apr 2010 15:26 Dear Mike, Please guide further, nothing change. the result still CLOSEDCLOSED, without the comma. TIA. "Mike H" wrote: > 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. > > > "Andri" wrote: > > > > > > > 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 > > > > "Ashish Mathur" wrote: > > > > > Hi, > > > > > > Download and install the following addin - > > > http://www.download.com/Morefunc/3000-2077_4-10423159.html and then use the > > > following array formula > > > > > > =SUBSTITUTE(TRIM(MCONCAT(IF((($B$2:$B$11=B15)*($C$2:$C$11=C15)),TEXT(A2:A11,"dd/mm/yyyy")," > > > ")))," ",", ") > > > > > > B15 has A and C15 has N > > > > > > -- > > > Regards, > > > > > > Ashish Mathur > > > Microsoft Excel MVP > > > www.ashishmathur.com > >
From: Ashish Mathur on 25 Apr 2010 05:09 Hi, Please post the original question again. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Andri" <Andri(a)discussions.microsoft.com> wrote in message news:11596B7D-16D0-4193-81D6-A2F5CDF09BE7(a)microsoft.com... > > > 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 > > "Ashish Mathur" wrote: > >> Hi, >> >> Download and install the following addin - >> http://www.download.com/Morefunc/3000-2077_4-10423159.html and then use >> the >> following array formula >> >> =SUBSTITUTE(TRIM(MCONCAT(IF((($B$2:$B$11=B15)*($C$2:$C$11=C15)),TEXT(A2:A11,"dd/mm/yyyy")," >> ")))," ",", ") >> >> B15 has A and C15 has N >> >> -- >> Regards, >> >> Ashish Mathur >> Microsoft Excel MVP >> www.ashishmathur.com >
|
Pages: 1 Prev: List the UNIQUE certain fields from the database Next: Format Data Labels |