String of dates convert to a from and to date

[Mikey G]

Hi

I have a spreadsheet with reference relating to dates that are listed as single days. I am trying to convert the single dates relating to a reference to a from and to date but i'm having problems.

Example

048051_141 10/09/2013
048051_141 11/09/2013
048051_141 12/09/2013
048051_141 13/09/2013
041929_141 15/10/2013
041929_141 16/10/2013
041929_141 17/10/2013
041929_141 18/10/2013

I want this to read

048051_141 from - 10/09/2013 - to - 13/09/2013
041929_141 from - 15/10/2013 - to -18/10/2013

Is this possible and thanks for the help.

[etaf]

you could use
=A1&" From - "&TEXT(MIN(IF($A$1:$A$16=$A1,$B$1:$B$16)),"DD/MM/YYYY")&" - to - "&TEXT(MAX(IF($A$1:$A$16=$A1,$B$1:$B$16)),"DD/MM/YYYY")
and format as an array using
control+shift+enter
rather than just enter

But can you pull out the codes and put in a cell - say D2 down

then you can use
=D2&" From - "&TEXT(MIN(IF($A$1:$A$16=$D2,$B$1:$B$16)),"DD/MM/YYYY")&" - to - "&TEXT(MAX(IF($A$1:$A$16=$D2,$B$1:$B$16)),"DD/MM/YYYY")

see attached
column H