Greetings Excel Gods!
I'm trying to find out: For each person (ID #), how many times have they been arrested following a program referral? Each arrest is in a separate row:
For each ID number in Workbook1 (column B), search Workbook2 for each instance of that number. For each instance found in Workbook2, look at the date in column D. If the date in Workbook 2 column D is greater than the date in Workbook1 column AQ, then count it and return the total.
Any help would be greatly appreciated. I was thinking that a vlookup would work, but that only seems to find the first instance.
Thanks!
I'm trying to find out: For each person (ID #), how many times have they been arrested following a program referral? Each arrest is in a separate row:
For each ID number in Workbook1 (column B), search Workbook2 for each instance of that number. For each instance found in Workbook2, look at the date in column D. If the date in Workbook 2 column D is greater than the date in Workbook1 column AQ, then count it and return the total.
Any help would be greatly appreciated. I was thinking that a vlookup would work, but that only seems to find the first instance.
Thanks!