Data range comparison

[iggy]

Hi, this is my first post to the forum.

I'm have a spreadsheet with a column of entries: "Pass", "Conditionally passed" or "Fail". I want to populate a cell with only one the most severe of the entries within the column. So if one instance of "Fail" appears populate cell with "Fail", likewise with "Conditionally passed", else populate cell with "Pass".

I'm have been using:
=IF(D8="Fail","Fail",IF(D8="Pass","Pass", IF(D8="Conditionally passed","Conditionally passed")))

for single cell comparison, but need to extend this over a range. I need to do this without using a macro.

Any help would be greatly appreciated.

[teylyn]

maybe

Please Login or Register  to view this content.

Adjust ranges to suit.

cheers

[iggy]

Works a charm, thanks for the quick reply!