Removing Duplicates with Excel 2007

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Advanced.excel · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Medium Priority · Version 2007

Luella has attended:
Excel Advanced course

by - delegate Luella [1 post] (2008 Apr 28 Mon, 16:47) Reply

How do I remove duplicates from a list with Excel 2007?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Aug 12 Tue	Bloomsbury	0	FULL
2003/XP	2008 Aug 12 Tue	Tooting	0	FULL
2003/XP	2008 Aug 14 Thu	Southwark	0	FULL
2007	2008 Aug 19 Tue	Bloomsbury	5	book now	£212	£224
2003/XP	2008 Aug 21 Thu	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Aug 21 Thu	Bayswater	4	book now	£195	£205
Full Schedule: See all 145 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Removing Duplicates with Excel 2007

by - trainer Rich platinum contributer [686 posts] (2008 May 4 Sun, 16:21) Reply

You can use Pivot tables or some formulas. This web site provides some good ideas: http://www.mrexcel.com/tip138.shtml

RE: Removing Duplicates with Excel 2007

by - trainer Rich platinum contributer [686 posts] (2008 May 4 Sun, 16:21) Reply

You can use Pivot tables or some formulas. This web site provides some good ideas: http://www.mrexcel.com/tip138.shtml

· How to Create Better Excel Spreadsheets: Part Two
· How to Create Better Excel Spreadsheets: Part Four
· Excel Macros for the Non-Programmer
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Benefits of learning about Excel charts

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips