Thank you for responding....This is what I have. One workbook with separate
tabs/worksheets. Each worksheet contain a list of people who may or may not
have taken a specific training yet. If they have completed the training we
identify them by hilighting them and checking them off. My task is to
consolidate the 4 trainings and determine who has taken what training. My
lay out is basically a list of names, addresses, etc.... for each specific
training. I don't know how to set up the formula or function. Not sure of
how to choose my values. Thanks.
--
Alma Brumley


"Fred Smith" wrote:

You need to supply more information.
What formula did you try?
How is your data laid out?
What determines whether someone has completed all the trainings?

Regards
Fred

"Alma Brumley" wrote in message
...
I have a workbook with different worksheets that tracks different types of
trainings a person has taken. Is there a formula that can pull data
identifying if a person has completed all the trainings? I attempted an
if
formula and it did not work. Help!!! Thanks you
--
Alma Brumley

.