Return value in range of cells using multiple criteria

[onthegreen03]

Hi All - I have a large data set which contains customer numbers and when they started or ended services with us. See the example below. In the top box is the actual data set, with multiple rows of data for the same customer. The bottom box is the result I need which summarizes each customer and combines when they started and ended throughout the time period. I toyed around with INDEX and MATCH to try to get the right result but it didn't work. Is there a formula/function I can use that will look for all results in a certain column and return that value based on customer number? Thank you!

 

[Fluff]

How about in C19 dragged down & across

=IFERROR(INDEX(C$4:C$15,AGGREGATE(15,6,(ROW($B$4:$B$15)-ROW($B$4)+1)/($B$4:$B$15=$B19)/(C$4:C$15<>""),1)),"")

 

[ISY]

Hi

365 BETA
C19 dragged down

=BYCOL(IF(B$4:B$15=B19,CONCATENATE(C$4:V$15),""),LAMBDA(array,CONCAT(array)))

 

[onthegreen03]

Thanks for the response Fluff, and as always you are amazing. Happy New Year!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Eric W]

Assuming no start and end on the same day, C19 copied across and down:

=CONCAT(IF($B$4:$B$14=$B19,C$4:C$14&"",""))