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