unique value by year

  • Thread starter Thread starter caj
  • Start date Start date
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
 
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)))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2016 - "Run-time error '287': Application-defined or object-defined error" while using CurrentItem.Saveas or CurrentItem.HTMLBody 4
Excel Subtracting multiple columns from another column 3
Pivot tables - counting unique numbers 2
Delete Non-identical but Similar Records 2
I need a unique number to be created per worksheet 2
Intel based Apple Machines, what happens in the future? 2
AI could eliminate 250,000 public sector jobs within 15 years 5
sum column D based on column A 1

Back
Top