Want a formula or a macro

 Hello Vishesh,


As per your instructions I have placed your code in to my sheet 1 , but when I run the macro I get compile error, I have attached the same file in which I pasted your code please try your self by running the macro and suggest what to do next...



ex.xls14.5 KB
Vishesh's picture


for solution chk this


I have provided a button on the sheet; click on it and see the results