filtering question

[Guest]

I have data in columns A and B. Column A is employee's names. Column B is
trainings they have attended. The person's name is duplicated several times
in A as they have attended multiple trainings.

I need a filter (or a code) that will list all staff who hasn't attended a
specific training.

It isn't as simple as filtering Column B to all rows that <> the specific
training because the person's names are duplicated in A because they have
attended other trainings. I don't even know who to work this clearly???

 

[Guest]

Hi,
Assuming date goes from row 2 to 100,
- in column C2, enter the formula:
=SUMPRODUCT(($A$2:$A$100=A2)*($B$2:$B$100<>"")*1)
it puts 0 when a person
- copy/paste this formula down along the data
- filetr on column C for ) (zeroes) : menu Tools > Filter AutoFilter
or use an Advanced filter to create a sparate list of unique names

Regards,
Sebastien