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...
Request a quote
- We offer a price match guarantee.
- No hassle set-up. Fully branded LMS with single sign-on and API integration.
- Desktop and mobile compatible. Train anywhere, anytime.
Once submitted, a member of our team will be in touch to talk you through your training options.