Searching single column and placing values in adjacent column

A B
10th St E08 10th St E08
11th St E08 11th St E08 11th St E09
11th St E09
12th St E08 12th St E08 12th St E09
12th St E09
13th St E08 13th St E08
15th St E08 15 St E08 15th St E10
15th St E09
15th St E10


Column A is my current Data. Column B is what I would like the results to show as. If there are 3 or more original values in column A(15th St), I would like to have the lowest and highest values show in column B.
Thank you in advance

Hi Huskersippi,

Suggest you to go through below thread :-

http://www.excelforum.com/excel-form...e-returns.html

Regards,
DILIPandey

<click on below 'star' if this helps>