one way:

In you master list, starting in B2 with names in A2:

=IF(COUNTIF(Training!$A$2:$A$1000,A2),"","Training needed")

Copy down

"Training" is worksheet with list of trained personnel

HTH

"dardiaca" wrote:

I have two lists: one with my entire population and the second with the ones
that subscribed a training course. Which function should I use to compare
both lists and highlight in a new column those who still need training?