@Abgijit2011

Your welcome. To give credit where credit is due the combinding of the array function comes from Chip Pearson and can be found at http://www.cpearson.com/excel/vbaarrays.htm.