Faseeh, this worked very well. Thank you for the prompt response!
I've used your formulas in my spreadsheet and it does pretty much what I want it to do. https://dl.dropbox.com/u/46514639/2013-03-05%20ID%20Card%20Data%20%28Test%29.xlsx
There are two things I'd like to improve and would...
I'm creating an import file for some test data. I have a list of certificates that are required for a particular job - typically 8 or 10 certificates for each position. I need to create an import file that contains a row for each certificate. The row includes the name of the certificate holder...