unique value by year

C

caj

I have multiple claim numbers with multiple dates. What I need is to get one
ocurrence of each claim number for a specific year
 
C

caj

I have multiple claim numbers with multiple dates. What I need is to get one
ocurrence of each claim number for a specific year
Click to expand...

This is formula I am using to get the claim number, but I need it to pull
only the claim number within a specific year

=IF(ISNA(MATCH(0,COUNTIF($B$20:$B20,Log!$A$2:$A$1000),0)),"",INDEX(Log!$A$2:$A$1000,MATCH(0,COUNTIF($B$20:$B20,Log!$A$2:$A$1000),0)))
 
Top