Dear Biff,

thank you for your kind excellent advice for the practical purposes.

Message noted, we will copy the each result into the each cells.

Now focusing on the UDF module.

thank you for your kind help to all of you.

have a nice weekend

respectfully,
andri

"T. Valko" wrote:

You can not do this (for all practical purposes) if you want all the results
to be concatenated into a single cell using built-in functions. You need to
use a VBA procedure.

--
Biff
Microsoft Excel MVP


"Andri" wrote in message
...
Dear TM,

still figuring out your formula and Mike's formula.

related your suggestion to use pivot table, i prefer to use formula
instead
of PT.

thank you and respectfully,
andri

"Teethless mama" wrote:

Try PIVOT table


"Andri" wrote:

Dear All,

Here is the sample database.

Date Salesman Region
16-Aug-08 A N
16-Aug-09 B E
16-June-07 C S
15-Aug-07 A S
15-Apr-07 B E
4-Sep-07 D N
4-May-07 E N
6-Sep-07 A N
3-Oct-07 B W
24-Sep-07 E E

i would like to concatenate for Salesman B and Region E(east) in A1, so
the
result will be "15-Apr-07,16-Aug-09"... which formula can solve it?

tried SMALL + sumproduct(but...this sum all the date in that arrays).

thank you for your kind attention and help.

respectfully,
andri


.