[learning05]

PLEASE SUPPLY RELEVANT INFORMATION:
Operating System Version: Windows 98
Problem Application Name & Version: Microsoft Excel 97
Problem Hardware Make & Model:
Error Messages:


I am going insane!  I have a column with a list of names - some of which are repeated.  I only want to count each name once, regardless of how many times it appears in the column.  No-one at work can help and I am now driving them insane too.  Less of a problem but can anyone answer this one:  What if 2 people have the same name and I want to link to date of birth to make sure I get everyone.

I hate computers!!!!!!  (couldn't even post this message to the right forum on my first attempt)


Louise

[Admin]

Hi,

I am running Excel 2000 so I am not sure if Excel 97 has this feature but...

Data > Filter > Advanced Filters
Select "Unique Records Only"

To undo:
Data > Filter > Show All