Extract a list of employees according to month

[YasserKhalil]

Hi everybody
I've an attachment which describes my request
I want to extract a list of employees according to March without paying attention to the year, just the month
Thanks a lot

[Bob Phillips]

Try this array formula

=IF(ISERROR(SMALL(IF(MONTH($B$2:$B$20)=3,ROW($B$2:$B$20)-ROW($B$2)+1,""),ROW(A1))),"",
INDEX($A$2:$A$20,SMALL(IF(MONTH($B$2:$B$20)=3,ROW($B$2:$B$20)-ROW($B$2)+1,""),ROW(A1))))

[YasserKhalil]

perfect
But what if the employee's name is repeated and I want the list of unique names

[GTO]

Cross-posted http://www.mrexcel.com/forum/showthread.php?t=482601

[p45cal]

Thanks GTO.
YasserKhalil, don't cross post, and if you must, tell people everywhere, where you have done so.

Pivot table solution in the attached.

[YasserKhalil]

Mr. P54cal
Thanks for help
I don't know a lot about Pivot Tables
Can you help me understand how you did it???