Filter By Unique Records

[Corticus]

Hi all!

I'm trying to filter a data-set for unique records, as follows:

Book4
	A	B	C	D
1	LastName	FirstName	Service	UnitsServed
2	Brooks	Steve	CM	0
3	Brooks	Steve	CM	0
4	Smith	Aaron	NTED	1
5	Smith	Aaron	NTED	0
6	Smith	Aaron	NTED	0
7	Smith	Aaron	NTED	0
8	Jones	Mike	CM	5
9	Jones	Mike	CM	5
10	Killy	Raymond	HDM	1
11	Watson	Dr.	EAR	0
12
13	wouldfilterto:
14
15	LastName	FirstName	Service	UnitsServed
16	Brooks	Steve	CM	0
17	Smith	Aaron	NTED	1
18	Smith	Aaron	NTED	0
19	Jones	Mike	CM	5
20	Killy	Raymond	HDM	1
21	Watson	Dr.	EAR	0
Sheet1

Any help would be greatly appreciated,
Thanks!
Corticus
This message was edited by Corticus on 2002-09-12 13:09

 

[lenze]

Date>Filter>Advanced Filter

Select Unique Records Only
Click OK

 

[Juan Pablo González]

Use Advanced Filter, check "Copy to another range", and "Unique records". The source data should be A1:D11 in your case.

 

[Corticus]

Duh...

Thanks guys, that's perfect.

Have a good one(evening/day whatever, wherever you are)!

Blessings,
Corticus