Excel data - compare and move data, perform calculations

I have an excel spreadsheet with two tabs. One has 100+k rows the other 30+k rows. Need to find duplicate data, combine non-duplicates and perform some calculations. This should be pretty easy for someone who has experience using formulas and/or Macros.