Thanks mate,

I tried your sample but when I try with my work sheet It does not work

The work sheet has 5856 rows,

I also paste those rows into your sample sheet and tried, but did not work , its only return 1.01 value to the first row.


Could you please help me

Quote Originally Posted by davesexcel View Post
Check out the amended code