ExcelBanter - unique value by year

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - unique value by year (https://www.excelbanter.com/excel-discussion-misc-queries/183639-unique-value-year.html)

caj

unique value by year

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

caj

unique value by year

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

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$10 00),0)),"",INDEX(Log!$A$2:$A$1000,MATCH(0,COUNTIF( $B$20:$B20,Log!$A$2:$A$1000),0)))

All times are GMT +1. The time now is 07:01 PM.