I have two tables, one each on separate sheets. The first is a list of applicants - each with a unique identifying number.
The second is a list of references for those applicants. The references include the unique number of their applicant.
I'd like to include a column on the sheet of applicants that identifies the number of references that have been received for each applicant.
The second is a list of references for those applicants. The references include the unique number of their applicant.
I'd like to include a column on the sheet of applicants that identifies the number of references that have been received for each applicant.