Look at the 10 th and 11 th row in Occupancy Consultant Sheet . the Name are Same (101 California ..) . I want to Remove the Duplicate Value in the Excel Sheet . Also i want to Add the Two Values in Column 3,5,7,9,11,13 .

For Eg : In Column 3 , I want the Value as 77+- = 77
In Column 5 , I want the Value as 103+- = 103
In Column 7 , I want the Value as 103+- = 103
In Column 9 , I want the Value as - + - = -
In Column 11 , I want the Value as 103+- = 103
In Column 13 , I want the Value as (N/A+N/A)/2 = N/a