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

excel advanced

ResolvedVersion 2003

Iain has attended:
Excel Advanced course

Excel Advanced

Dummy question

RE: Excel Advanced

Iain

Thank you for your question, you now have 12 months support from the forum

regards

Best Team

Wed 13 May 2009: Automatically marked as resolved.

Excel tip:

Create a unique items table from a duplicating table

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.

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.11 secs.