Unique Data Filter Help

[Carlos]

Hi, say I have a column of Names: James, Jack, Jack, Jill.

I want to use a filter to eliminate all the duplicate data and leave
just James, Jill. Using advanced filer>unique>unique records only
leaves me with James, Jack, Jill.

any help to solve my simple yet annoying problem?


thanks

 

[Peo Sjoblom]

Use data>filter>advanced filter, copy to another location and unique records
only
if necessary delete original data

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Aladin Akyurek]

Let A1:A5 house the sample you provide with Name in A1 as added label...

{"Name";"James";"Jack";"Jack";"Jill"}

Format A1 distinctly, say as bold.

Leave C1 empty
In C2 enter:

=COUNTIF($A$2:$A$5,A2)=1

Finally...

Step 1. Select A1:A5.
Step 2. Activate Filter|Advanced Filter.
Step 3. Check "Copy to another location."
Step 4. Enter $A$1:$A$5 as List range.
Step 5. Enter $C$1:$C$2 as Criteria range.
Step 6. Enter $C$3 for Copy to.

Leave the Unique records only option unchecked.

Click OK.

The above can also be effected by means of an efficient formula system, but
that is left out here.

 

[Peo Sjoblom]

I apologize for reading your post so sloppy. Go with Aladin's suggestion

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)