When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for identifying and removing duplicate data.
One of the easiest ways to locate duplicate data in Excel is to use conditional formatting. Here's how.
Step 1: Select the portion of your data where you want to locate duplicates. In our example, we're selecting our entire table. Note that conditional formatting won't work if you are using pivot tables in Microsoft Excel.
Step 2: Select Conditional Formatting from the Home menu, then choose Highlight Cell Rules > Duplicate Values...
Step 3: You'll be presented with a dialog that lets you select whether to show duplicate or unique values (we want the former, of course) and how you want the data highlighted. You can choose from the drop-down list or create a custom format.
Step 4: Once you've selected an option or clicked OK, your duplicate data will be highlighted. This can be textual or numeric data, and it can include any number of columns.
You can also elect to have Excel remove any duplicate data from your spreadsheet. Use this function with caution – it's probably a good idea to back up your spreadsheet first.
Step 1: First, select the columns where you want to remove duplicates. Here, we're selecting the entire table. Note that Remove Duplicates will only remove those items where the values are identical across rows or from individual cells if a single column is selected.
In our example, the last three rows contain duplicate data.
Step 2: Select the Data menu, then click Remove Duplicates. In the dialog box that pops up, you'll be presented with several options. First, you can identify if your data has headers. Second, you can choose which columns to include or exclude.
Step 3: You'll be presented with a dialog that will indicate how many duplicate values were found and removed and how many unique values remain. Note that the last three columns in our data were removed.
Note that it is also possible to use VLOOKUP in Excel to find duplicate data.
Getting to grips with these advanced features turns what appears to be a plain grid of numbers into a powerful tool. Want more tricks? Here's how to use the concatenate function in Excel.
Did you think hitting delete on your AI chatbot conversation actually makes it disappear? Georgia Tech researchers just proved that's not entirely true. They have built a forensic tool called ORISA that can dig deleted conversations from your phone and even rebuild them into a working chatbot session you can keep talking to.
How can ORISA bring deleted AI conversations back?
Touchscreen laptops have been around for years. You can get them in all sizes and shapes. Just not from Apple. For years, the Cupertino giant has treated the idea of a touchscreen MacBook the way I treat a meeting that could have been an email: with open contempt. However, Wednesday looks like the day the company could finally change its mind.
The latest Apple invite puts the “Pro and Tell” showcase in Los Angeles at 10 a.m. PT (1 p.m. ET) on October 28, 2026. Instead of a regular live-streamed keynote, it is an invitation-only, hands-on event for a handful of press and creators (similar to what the company did for the MacBook Neo earlier this year).
Two residents of Chicago have filed a lawsuit in the US over claims that robots run by Coco Robotics and Serve Robotics captured their facial and hand measurements without consent, bringing renewed attention to the food delivery robots. The cases raise a troubling question: If a robot delivers food to your door, can it also be gathering sensitive information about you?
According to a report by The Associated Press, the proposed class-action lawsuits were filed in Cook County on Oct. 9 and allege violations of Illinois’ Biometric Information Privacy Act. The complaints claim that the robots’ cameras and LiDAR sensors captured information on customers’ faces and hands as they approached the machines to pick up their orders. Both have denied the allegations.