Extracting field as with gsheets filter function

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

Goshdarnitall, I'm on a Mac, and for the life of me neither Control-Shift-Return [Enter] or Command-Shift-Return will take. (Powerbook; there is no separate Enter key...) Just sits there like I haven't hit any key. I've tried every imaginable combination, including adding the Function key. Can't get curly brackets.

I think this may be a powerbook thing, but I think It also reminds me why I've never gone deep with array formulas.

IAC your formula looks right and seems to work right from your example. Many thanks will keep banging my head against the wall here..

Found the answer: Array functions don't work at all in Excel Online. Can see results in uploaded sheets, but can't create, edit, or recalc. Wanting this to be a workbook that multiple people can use.

And even in the app, Excel's concatenate doesn't work with arrays from formulas. In my app this would mean dozens of extra (hidden) columns and potential complications.

So sad to say, for multiple reasons, Excel's just not up to the job.

Thanks again so much for your help. Almost got there...

Steve