Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Filter/Unique Records

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Advanced Filter/Unique Records

Resolved · Medium Priority · Version 2003

Reply Tue 31 Jan 2012, 14:48Delegate Kate said...

Kate has attended:
Excel Advanced course

Advanced Filter/Unique Records

Hi,

I am trying to use the advanced filter to provide me with unique records.
I have a spreadsheet with repeated numbers in cells in column A, but with different information in the columns to the right. I need to filter column A to only show unique records, I have tried to use the advanced filter, but it doesn't seem to be working. Could someone please help?

Thanks

Kate

For upcoming training course dates see: Pricing & availability

Reply Tue 31 Jan 2012, 16:52Trainer Doug said...

RE: Advanced Filter/Unique Records

Hi Kate

It may be worth trying this out first to see how Advanced Filter works in Excel 2003.

On a blank sheet Type Month in A1 and Jan in A2. Then autofill A2 down to A40 so there are several duplicate months Nov, Dec, Jan etc. Then click in A1 and bold.

1. Select Data, Filter, Advanced Filter.
The range A1:A40 should become the List range.
2. Click Copy to another location then click on a black cell eg C1.
3. Tick Unique records only.

You should see only 12 months now in C1:C12

Let me know if that helps first. It will give you a unique list of the data you have in column A.

Only if your table contains duplicate records will they be removed in the same way.

Doug

Doug Dunn
Best STL

Reply Wed 1 Feb 2012, 09:28Delegate Kate said...

RE: Advanced Filter/Unique Records

Thanks Doug, that works, it seems I was trying over complicate things!

Kate

Excel articles

· Finding Your Way Around Excel 2007
· Excel 2010 Can Make Your Reports Better And More Detailed Than Ever
· Do You Need To Upgrade From Excel 2003 to Excel 2007?
· How To Add Extra Data Ranges To An Excel Chart
· Advanced level training: Microsoft Excel and the Web

Please browse our web site to find out more about
advanced excel ms training and other Microsoft training courses.

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips