Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top