how to show who in this month Expiry

zEr · #1 05-08-2016, 10:30 AM

hello everyone.
i try to show who's name Expiry Date in this month of year (May,2016)

in this function or any function fix this.

=IFERROR(INDEX($C$2:$C$16,SMALL(IF($F$2=B2:B16,ROW (C2:C16)-1,""),ROW()-3)),"")

all help will be appreciated
Thank you

xor · #2 05-08-2016, 10:49 AM

Perhaps like the attached.

zEr · #3 05-08-2016, 10:56 AM

Thank you so much xor

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Expiry Date Excel sheet!	Emperor	Excel Programming	6	10-27-2015 11:50 PM
Expiry date in excel	splinter09	Excel	3	12-10-2014 06:09 AM
How to show just day and month	ketanco	Project	2	06-14-2012 03:25 PM
Day and Month to Uppercase	Andy2011	Word VBA	1	07-22-2011 04:34 PM
Question: Hyperlink to other show, but close the current show	habibfikri	PowerPoint	0	12-26-2010 02:37 AM