Functions

D

dardiaca

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?
 
T

Toppers

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
 
Top