Wow that does what I want but still if I drag this formula for 1000 rows will that not slow up my workbook ??
I feel it will and that's why I am searching for a macro that would do the same any idea how to achieve it!!