delete duplicate rows

  1. G

    VBA - delete duplicates rows, add sum of 1 column

    Hi Guys, I need your help with my vba code. :) I need to locate the duplicates from column A, leave just 1 row of that column and add the sum of column N (the rest of the columns don't matter). Below it's an example of my raw data (A column and N column) Account number Amount 102105709...
  2. R

    Copy paste usedrange data and delete duplicate rows

    Hi friends, I need your help, below are the things which i am trying for my code to perform. • Copy data from range B5:F13 (range will not be fixed) • Go to sheet “Archive” paste copied range as value from cell A3 • Delete duplicate rows from sheet “Archive” (Like in the sample file last two...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top