Affinity Consulting Blog


Larger data sets tend to have duplicate content. You might be copying information form multiple lists or speadsheets and want to remove any duplicate content. In situations like this, removing the duplicates comes in quite handy.

To remove your duplicates, go to the Data tab, and select "Remove Duplicates" (under Tools). A pop-up will appear to confirm which data you want to work with. Select the data set and select "Remove Duplicates" and you're good to go. This will remove duplicates for the data set you selected. For example, if you have a list of names and email addresses, you can remove duplicate email addresses to organize you list. our resulting list will have only unique names without any duplicates.

Need more Excel help or Microsoft Office help in general, please reach out to us at This email address is being protected from spambots. You need JavaScript enabled to view it.

Let's Get Started Today

with a plan that's right for your practice.

Let Us Teach You

Take advantage of our blog resources, sign up for our law office technology white papers, take a course from Affinity University, Attend all of our Live Events.

Start Now


Hire Us To Do It For You

Hire Affinity Consulting Group to make your law office run more efficiently than ever… We can deliver the hardware, the software, and the training that is perfect to make your law office more efficient.

Start Now


Work With Us

We can give you expert guidance, helping you make smart choices for your law firm. We can help you analyze your current situation and make suggestions that will point you in the right direction.

Start Now


Sign up for our newsletter and

keep your law office efficient.

Join over 4,000 successful law firms who receive our newsletter today.

Email:

Read Our Previous Newsletters