duplcates

I can't use xlbb add-in since my company disabled add-ins. I have a list of companies that I need to clean up the duplicates. Some company names are very similar or have a comma or period in the name or some other extra value. How can I remove them easily. I think the best way would be if the...

Hello, I am trying to find out how to identify near duplicates in a large excel sheet based on a monetary value. For example, If i have 2 rows I want to be able to highlight these as potential duplicates if the number is within certain criteria. Is there a formula that I can create to say: If...

Good day, I am carrying out an analysis of data submitted. the nature of the analysis is to seek variances in the data. one of the variances is multiple submissions on the same data. what I am aiming to do, is to cut all the first occurring duplicates to the bottom of the data. I have already...

In the following context when I say randomly it means in a random order so every recalculate could move the results around. In this example I am trying to randomly display these 3 colours without duplicating, e.g no red, red, red or red blue red...

For our business we have an excel sheet we track income on. Each month has its own sheet then i have a client sheet where i want to make a list of all clients in each month ignoring the duplicates and also trailing spaces and capitalization. SO basically i need to use VBA to pull First Name...

I have a strange question and I am going to do the best I can to explain it. I have a large list of invoice numbers and vendor numbers, and I want to look for possible duplicate payments. I can easily write a formula to find a duplicate of the same invoice number but is there a way to find one...

I have two columns of data, one contains a unique identifier, the other contains another 4 digit key. What I want to do is for the unique identifier when there is more than one 4 digit key that is associated to it, I would like to to display x. Marking both entries not just the first or...

Hello, I'm in the process of expanding on a macro to look at customer ID and the product name they ordered. If they ordered a set of a particular product then it will combine both product name into one and delete the oldest record. I have created another tab that combines the product...

Hi, I am just wondering if anyone knows why after each time I do a left join merge with Power Query I get a lot of duplicate rows? Is there a reason within my data for why this is happening or is it something that happens normally? Thanks!

I'm having some problems with this dataset below and don't know what to do. For each group of of common ids I want to delete their respective duplicates based on their status and their date and time stamp. If the status for all the common trade ids is "rejected" then I want to delete all trade...