Module 22 : Remove Duplicate Values
22.1 Remove Duplicate Values in Excel Sometimes you have duplicate values in a range of data that are not useful to you. Rather than deleting them one by one you can remove duplicate values using an Excel function. To do this, select a cell or a range of cells. Then go to the Data tab, and find the Data Tools group. Here, click Remove Duplicates. Then, under Columns you can select one or more columns where you would like data removed. You can select all columns by clicking Select All...
Get a quote
- We offer a price match guarantee.
- Set-up is simple, with a fully branded LMS, single sign-on and API integration.
- It works on desktop and mobile, so your team can train wherever suits them.
Once you’ve sent your details, one of our team will be in touch to talk you through your training options.