Help on Filtering

[Eladamri]

Hi,

I have a spreadsheet with a list of names in column A and some detail
about them on column B. in a single name there are about 20 or mor
details about them so the manes are repeated over and over again.

My Question is How can I display their names only once in column A.
just need to get the names of the employees on the spreadsheet.

Example:
Column A Column B

Mr. A B-day
Mr. A Adress
Mr. A School
Mr. A .......
Mr. B B-day
Mr. B Adress
Mr. B School
Mr. B .......
and so on....


Filter it to:

Column A
Mr. A
Mr. B
and so on...

 

[Larry S]

I'm making an assumption that what you need is simply a list of all the
Employees identified in column A and that list can be seperate. Assuming
this is correct, I would use a Pivot Table. At the very minimum the range
for the table would be column A.

 

[Ardus Petus]

Use Data>Advanced filter
Check Copy to another location
Fill in List range
Check Unique Records only
Click OK

Et voilà!

Cheers,
--
AP


"Eladamri" <[email protected]> a écrit
dans le message de (e-mail address removed)...

 

[Eladamri]

Excel promted me that the "Database or List Range is not Valid".
do you know what went wrong in the advance filter?
Here is a sample:
Name
Mr. A 1
Mr. A 2
Mr. A 3
Mr. A 4
Mr. A 5
Mr. A 6
Mr. A 7
Mr. A 8
Mr. B 9
Mr. B 10
Mr. B 11
Mr. B 12
Mr. B 13
Mr. B 14
Mr. C 15
Mr. C 16
Mr. C 17
Mr. C 18
Mr. C 19
Mr. C 20
Mr. C 2

 

[Ardus Petus]

In C1, enter: Name

Use C1 as List Range

HTH