to CONCATENATE from the smallest date with at least 2 criteria
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
|