Excel Forum

Excel Magic Trick 728: COUNTIF & AND Functions Check Whether 3 Specific People Worked Together

Download file: http://people.highline.edu/mgirvin/
Learn how to check to see if the names Chin, Brandy and RC all appear in the same row with AND and COUNTIF functions and array tricks.

Got a Question? Ask it Here in the Forum.