Hello,

I'm looking for a macro to concatentate the earliest date and the latest date in column A separated by "-", but only from the rows in which column B is the same. Additionally if the value in column B only appears once then just return the date from Column A.

Column A Column B Column C
9/16/2017 A 13 Sep - 16 Sep
9/16/2017 B 12 Sep - 16 Sep
9/15/2017 B 12 Sep - 16 Sep
9/13/2017 A 13 Sep - 16 Sep
9/13/2017 C 13 Sep
9/13/2017 B 12 Sep - 16 Sep
9/12/2017 B 12 Sep - 16 Sep

Thanks in advanced for any help or advice,

chiatbw