Blog

Tip of the Week: Remove Duplicate Values in Excel

Tip of the Week: Remove Duplicate Values in Excel

Microsoft Excel is a great tool that can provide loads of value to power users, but oftentimes users just don’t have the know-how to make the most of it. Thankfully, you have power users like us to guide you through some of the more intricate processes in the spreadsheet software. Let’s look at one such process: removing duplicate values in columns.

How to Remove Duplicate Values in Columns

It turns out that Microsoft Excel makes this process extraordinarily easy to pull off. There is an option built right into the program which enables you to do this. Begin by opening up whichever spreadsheet you want to remove duplicate values in.

Next, select the cells which comprise the spreadsheet. If you want to do the whole spreadsheet, you can use Ctrl + A to select the entire thing.

The next step is to go to the Data tab and select the Data Tools button in the ribbon. From here, you select Remove Duplicates from the drop-down menu. A menu should open up with some options to choose from. If you want to keep your headers, if your spreadsheet uses them, then select the box for My data has headers. This will ignore the first row of your spreadsheet.

Underneath this option, you should see the list of columns in your spreadsheet. Select the columns for which you want to delete duplicate values. To make things easier, you can use the Select All or Unselect All options at the top of the box. Once you are ready, you can click OK. A dialog box will appear telling you how many duplicate values have been deleted, as well as how many unique values remain.

And that’s it! Super easy, right?

What are some other tips you would like to see from us in the future? Be sure to let us know in the comments, and for more great tips and tricks, subscribe to White Mountain IT Services’s blog.

Related Posts

If you want to optimize productivity, then you’ll want to take a look at the startup page for your Google Chrome web browser. If you change this setting, you can shave off countless minutes every week while you fumble around trying to find your favor...
How often do you receive emails from someone written in another language? We bet the answer is “not often,” but you never know when being able to translate an email might come in handy—especially if you ever do business overseas. Let’s go over the bu...

In what seems to be the final stage of a plan that Microsoft has been inching towards for years, Microsoft Office will apparently be phased fully into the Microsoft 365 brand. Let’s consider what we know so far about this change.

When working in your browser, we know how efficiency is extremely important. Like many other pieces of software the developers at Google have baked some keyboard shortcuts to make getting around their browser easier for the average user. Let’s take a...
It’s a great feeling, being able to download something, but also being able to download it as a PDF file. In cases where you want to save something as a PDF rather than its original image or web page file, you can do so relatively easily in order to ...
If you use Android mobile devices, then you’ll know that updating your device is routine maintenance to keep it safe from threats and security breaches. Not only that, but updating your device can resolve various bugs which impact functionality. Let’...
We are major advocates for multi-factor authentication, but it’s also important to understand that it’s not a catch-all solution. In fact, it has forced cybercriminals to be even more innovative to find alternative methods of attack. One method hacke...
We’ve all accidentally swiped away an important notification on our mobile devices, but not all of us know that Android devices give us the opportunity to go back and check them. For this week’s tip, we’re going to go over the process of how you can ...
Sticky Keys—the Windows accessibility feature that keeps modifier keys like Shift and Ctrl active after you’ve pressed them—have a legitimate and necessary purpose for some. However, those who don’t need Sticky Keys can find them immensely annoying. ...
With so many employees working remotely, it’s important that you do all you can to ensure they have set themselves up for success with their home office. To this end, we have put together a list of suggestions you can use to help your employees build...
When all is said and done, being a manager is a far different experience than being an employee. So, when you promote one of your team members to this position—or perhaps you’ve recently been promoted to management yourself—it is important that a few...
One of the fastest-growing services in healthcare is telehealth. If you aren’t familiar with this concept, it is basically a virtual meeting designed to provide faster and more direct healthcare consultations and stabilize the ever-rising costs of he...

Onsite Service Coverage Area

Although we provide remote services and support to businesses in over 20 states, onsite services are limited to within reasonable driving distance from our offices in NH.  We will manage a local vendor for locations outside of our service area to provide onsite assistance when needed.

 

Onsite Computer Support Services are available to businesses within 60 miles of Nashua New Hampshire. We have excellent onsite coverage from Concord NH, south through Manchester NH, and then down into Boston. From Northern and Central Mass, we cover from Worcester, east to the North Shore, including the Salem NH and Portsmouth NH area.

White Mountain IT Services

 


33 Main St, Suite 302
Nashua, NH 03064

 


121 Riverfront Drive
Manchester, NH 03102

 

Client Help Desk
603-889-2210

 

Open Positions