unduplicate

  1. L

    Counting Non-Duplicated Entries Across Multiple Sheets

    I have a workbook that I use to keep track of volunteers. One sheet per month, along with a totals sheet. I use the formula =SUMPRODUCT((B7:B150<>"")/COUNTIF(B7:B150,B7:B150&"")) to count the number of unduplicated volunteers per month, but I need to count the number of unduplicated volunteers...
  2. J

    Unduplicate values in two columns; unique values in column C

    Hello I am trying to unduplicate two columns, each with over a half million values so stacking them is impractical. I want to create a third column containing the unique values from the first two. _A_ _B_ _C_ 123 456 123 456 789 325 325 623 456 ___ ___ 623 ___ ___ 789 Thanks!

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