VBA Macros Help

Hai

Can Some One Help in One Small Application. I want to Remove the Duplicate Name in the Excel Sheet .
Please See the Row 10 and 11 and it Contain the Duplicate Name

I want the Output As Follows

101 California - 77+2 = 79 in Column 3, 103+2=105 in Column 5,103+2=105 in Column 7, - + -= - in column 9 , 103+2=105 in Column 11 and 10+20/2=15 in column 13

Before that I will tell the Value For Each Column that is Stored

E Column Value is C12*12/9
G Column Value is E12
I Column Value is G12
K Column Value is G12-I12

Can Some One Help me to Solve

Thanks and Regards

Madhu.R

Where on earth does the 2 come from in your calculations??? because it is not on the sheet. Is it the count of how many duplicates it finds???