HI,

I have checked the formula as it is array related it is taking too munch time for calculation and will be very difficult yo use the workbook.
c:c 1048576 Row
So better updated the range manually

2) U can ask help Preparation of VBA Code
Punnam