Subscribe Bookmark RSS Feed

Grouping Sets of Data?

I have 10 rows of data with the same SN, a few columns listing different test criteria (the combination of the test criteria creates the 10 rows), and then a final column stating whether or not the SN passes or fails given the test criteria. I want to create some sort of formula that looks across all 10 rows of the given SN and determine if there are any fails. If there are any fails at all I want to mark ALL 10 rows as fail.

Is there an easy way to do this?