Compare mutliple Excel columns

Solved/Closed
Sonja - Oct 18, 2010 at 01:01 AM
 Sonja - Oct 18, 2010 at 12:45 PM
Hello,
I'm working on an excel sheet and comparing multiple columns to determine if a
site to be eligible or not eligible for the program, the site can only have Failed one shop period or less. If the site Failed 2 times or more, they are not eligible. So based on the 3 shop periods shown, i'm trying to place either an 'eligible' or 'not eligible' in the empty column to the right.

SVB 2009 S1 2009 S2 2009 S3 Eligibel or Not Eligible
2287241 PASS PASS PASS
2287332 PASS PASS PASS
2289734 FAIL PASS PASS
2290385 PASS FAIL PASS
2291441 PASS PASS PASS
2291664 PASS PASS PASS
2291730 PASS PASS PASS
2291920 FAIL PASS FAIL
2292019 FAIL FAIL PASS
2292134 FAIL PASS PASS

Can someone please assist in identifying a formulla to easily produce an output for this query.

Related:

2 responses

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Oct 18, 2010 at 11:42 AM
Hi,

Use this formula :

=IF(COUNTIF(B2:D2,"FAIL")>=2,"Not Eligible","Eligible")

Best regards
0
Thank you so much that worked prefectly.
0