Originally Posted by
63falcondude
I agree with post #2. If you have 7 years where each year has 500 rows, that's 3500 rows which Excel can handle much easier than splitting it up into separate sheets.
That being said, something like this (also suggested in post #2) should work:
B6 =IFERROR(IFERROR(IFERROR(INDEX('2017'!C$4:C$500,MATCH(0,IF('2017'!A$4:A$500=B$3,COUNTIF(B$5:B5,'2017'!C$4:C$500),""),0)),INDEX('2016'!C$4:C$500,MATCH(0,IF('2016'!A$4:A$500=B$3,COUNTIF(B$5:B5,'2016'!C$4:C$500),""),0))),INDEX('2015'!C$4:C$500,MATCH(0,IF('2015'!A$4:A$500=B$3,COUNTIF(B$5:B5,'2015'!C$4:C$500),""),0))),"") Ctrl Shift Enter
Copy down as far as needed.
Bookmarks