Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel training class - duplicates rows table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training class - Duplicates rows table

microsoft excel training class - Duplicates rows table

ResolvedVersion Standard

Steve has attended:
Excel Advanced course

Duplicates rows table

What is the best way of automatically deleting duplicate rows in an Excel table to generate a non duplicated table?

RE: duplicates rows table

Well there are several ways you could tackle this.
First, make a copy of your file, so that if you make a mistake, you can go back to the original.


Here are the steps:

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

Copy and paste filtered list to desired location.

DONE

That is one simple way of doing it.

Richard

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.