Create a list from a Table by selecting a year.

JBeaucaire,

Thanks for your time. The sample is just what I was looking for, however I don't seem to understand it formula as well as I thought I did as witnessed in my attached file. I think my problem is in the "Rows" section of the formula.

I can get the formula to display a list of names but not the correct ones. The attachment is a clearer example of my goal. I like the formula but I just cant quite get my brain around it fully.

Thanks for the help.

Jim O