Match multiple cells

[AMAS]

Hi everyone,

I'm stumped on how to solve this with a formula or vba.

I have a list of student IDs in a column (A). Column B contains the classes they took. Column (C) contains their final assessment (pass or fail). The student IDs are unique to each student but recur multiple times (varying depending on how many classes each student took). I am trying to get see how many students passed all their classes without having to manually filter each ID and eyeball the results.

Any thoughts?

AMAS

 

[shg]

Pivot table?

 

[AMAS]

I was afraid you were going to say that. It's one of the things on the 'to learn list'.

AMAS

 

[Yahya]

could you give us small sample from data

 

[yogeshmaney]

Then Why not sort, coz ur asking for just data duplication.

 

[AMAS]

Thanks everyone for your suggestions. I have been thinking about how to best accomplish this and realized that I can use a formula with a combination of Countif and Countifs to determine if the students passed all their classes or not.

=IF(COUNTIF(A:A,A2)-COUNTIFS(A:A,A2,C:C,"Fail")>0,"Pass","Fail")

AMAS