Hai,

I am New to VB Macros .I attached One Sample along with this post. In the 13 th Column of the Sheet , I want to Calculate the Percent Value .

In the Sheet , It Deletes the Duplicate Value after Added the Value in the Column 3,5,7,9,11 and 13 . I want the Thirtenth Column asFollows

1) IF row 1 13 th column value is 10% and row 2, 13 th column value as 20 % , i want the Output as (10%+20%)/2 = 15 %

Can Anyone Modified that Sheet and Send me .

thanks