Thread: how to show who in this month Expiry
View Single Post
 
Old 05-08-2016, 10:30 AM
zEr zEr is offline Windows 10 Office 2007
Novice
  
Join Date: May 2016
Posts: 8
zEr is on a distinguished road
Default how to show who in this month Expiry
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
Attached Files
File Type: xlsx all-duplicates.xlsx (12.0 KB, 15 views)
Reply With Quote