dedupe

  1. G

    De-duplicating/merging rows while keeping any data

    I need to determine whether any people have downloaded any applications. But the database that spits out whether a person has done so can only generate lists for one application at a time. So, I have one spreadsheet showing that Bob downloaded Messenger, and another showing that Bob downloaded...
  2. L

    Power Query: Removing duplicate values in Multi-Value Cells

    Hi there. Long-time Excel user and dabbler in VBA and Power Query. I've got a variation on a problem I posted a few years ago in this thread. There, folks helped me use PowerQuery to collapse data, combining multiple rows into single, multi-value cells while removing duplicates. The wrinkle...
  3. B

    VBA to Concatenate one column data in excel and dedupe additional line items

    Hello, Apologies if this is already on here - I did a search but was not successful in finding anything that is exactly what I'm looking for (and my VBA knowledge is limited...) I am looking to take data I have in an excel spreadsheet and concatenate one column's data for a referenced "tag"...
  4. K

    deduping, formatting and counting the dupes

    I have a need to dedupe a keyword list in Excel 2010. Easy enough. But some of the keywords have "" in them. First off how can I remove the quotes from every cell in a column? Then when I goto dedupe I need to count how many times a keyword was found to be a duplicate. The keyword list is...
  5. P

    Sort, dedupe, merge and format in excel

    I need to send out a holiday email to our clients and have all their data in excel. Simple enough, but I need to create a field/column that shows who in my company the email is from taking into account that in most cases each contact needs to have more than one person appearing in the “from”...

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