Formula to list unique names that match criteria.

I am working with a fairly large data set and it would be helpful to find a formula that can give me a list of unique names with no duplicates that meet certain criteria. For example only unique names that belong to a certain team. I have attached an example of what I am looking for with a "Data" and "Desired Results" tab.

Any help would be greatly appreciated!jxprestosample.xlsx

You can put the information into a pivot table. Whenever I hear the phrase "list of unique names" I think of pivot tables. It's the quickest way of getting a unique list of anything. In your case, you can use the Team Name as the report filter - make sure you enable the multiselect.

Originally Posted by AlKey

Don't know how big is your data set but give this one a try.

Enter formula in A2 on your Desired Results sheet and copy down

Formula:

Please Login or Register  to view this content.

I think we're on the right track as this worked with my example unfortunately I now realize that I may have left out some relevant information. My dataset will change in size from month to month and may contain blank "Name" records that should be ignored. I believe that is what is causing my formula error. Is there a way this can work if I set the range to a large value and have it ignore blank records?

If you make your data source an excel table and use it as the source for the pivot table, then as you add or delete names, the table will grow and shrink with the data. You can either filter out blank records on the pivot table, or you can add a helper column to the excel table indicating whether the name is blank and use that as an additional report filter.

For information on Excel Tables see this wiki: http://www.utteraccess.com/wiki/inde...ables_in_Excel