Hi All:

I'm trying to re-create something I've done in Google Sheets, with its Filter function. Any ideas much appreciated.

That workbook is here:

https://docs.google.com/spreadsheets...it?usp=sharing

See the third sheet, Clients' Activity.

Here's the gist. Start with this table:

6/27/15 Rhonda
7/1/15 Rhonda
7/11/15 Carrie
7/18/15 Carrie
2/4/15 Carrie
5/22/15 Barbara
2/11/15 Barbara
2/15/15 Barbara

And generate this as a separate, live-updated table:

Rhonda 6/27/15, 7/1/15
Carrie 7/11/2015, 7/18/15, 2/4/15
Barbara 5/22/15, 2/11/15, 2/15/15

There are actually more columns, and the extracted dates are filtered, only pulling those that match certain conditions. but if I could just do the above in Excel using fairly basic functions (eg no VBA/User Defined Functions, no macros), I'd be happy.

I do a pivot table to get a list of unique names, then use this formula for each name:

=iferror(
ArrayFormula
(concatenate
(text
(filter($A:$A, $C:$C=$A6, $F:$F=C$4, $A:$A>=$D$2, $A:$A<=$E$2),
"mm/dd/yy")
&char(44)&char(32)
)
)
,"")

Filter is the crux. Syntax is Filter(SourceField,Condition,Condition,Condition,...)

It pulls an array of dates from the source field where records match the criteria. Text converts to text-date format. Concatenate puts the array entries in one string with comma-space separating, etc etc.

I just can't figure out how to do similar in Excel. Any thoughts are very welcome.

Thanks,

Steve