The answer I gave in this thread appears to be literally exactly what you need, too.

http://www.mrexcel.com/forum/showthread.php?t=367946#5

That uses two formulas to create the unique list of IDs in one column, then the JoinAll function from Jindon to create the dates in the next column, separated by commas.

Sheet3

A B C D E 1 User1 1/1/2009 User1 1/1/2009, 1/2/2009, 1/3/2009 2 User1 1/2/2009 User2 1/4/2009, 1/5/2009, 1/6/2009 3 User1 1/3/2009 User3 1/7/2009, 1/8/2009 4 User2 1/4/2009 5 User2 1/5/2009 6 User2 1/6/2009 7 User3 1/7/2009 8 User3 1/8/2009

Spreadsheet Formulas

Cell Formula D1 {=INDEX($A$1:$A$1000,MATCH(0,COUNTIF($A$1:$A$1000,"<"&$A$1:$A$1000),0))} E1 =joinall(D1,$A$1:$B$8,", ") D2 {=IF(COUNTIF($A$1:$A$1000,">"&D1),INDEX($A$1:$A$1000,MATCH(COUNTIF($A$1:$A$1000,"<="&D1),COUNTIF($A$1:$A$1000,"<"&$A$1:$A$1000),0)),"")} Formula Array:

Produce enclosing { } by entering

formula with CTRL+SHIFT+ENTER!

Excel tables to the web >> Excel Jeanie HTML 4

## Like this thread? Share it with others