Filtering multiple returns

[JEllison]

I have a raw data page which contians peoples name and where they charged thier time. My problem is that I only want thier name to appear once. What type of formula do i need to use to make this happen.

Ex
Employee name Project No. WBS Code Hours
John Smith 123456 1 4
Jane Doe 123456 1 2
John Smith 123456 2 2
Jane Doe 123456 2 1
John Smith 123456 3 2
Jane Doe 123456 3 5

At the end I want to do a count to let me know how many people I have charging the job but I don't know what formula I need to exclude duplicate entries.

Thanks

[djt76010]

This isn't the cleanest way, but assuming your names are in the range A2:A10 you can add a column with the function =COUNTIF($A$2:A2,A2) in ROW 2 and then copy that formula into the rest of the column. ROW 10's formula would be =COUNTIF($A$2:A10,A10). In this new column, you can filter for the value 1 and it will only show the 1st record for each name. Assuming the new column is COLUMN K, you can also use the COUNTIF function again to tell you how many unique Names there are =COUNTIF($K$2:$K$10,1)

[ChemistB]

Do you want it set up such that the same person cannot put their name into column A a second time or are you looking to just count the unique names?
The first can be done with Data Validation, the second with Advanced filter.

[djt76010]

You could also summarize the data in a PivotTable and put the "Name" in the Column

[JEllison]

Thanks everyone.