Compare mutliple Excel columns
Solved/Closed
Related:
- Compare mutliple Excel columns
- Excel date format dd.mm.yyyy - Guide
- Beyond compare - Download - File management
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
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
Oct 18, 2010 at 11:42 AM
Hi,
Use this formula :
=IF(COUNTIF(B2:D2,"FAIL")>=2,"Not Eligible","Eligible")
Best regards
Use this formula :
=IF(COUNTIF(B2:D2,"FAIL")>=2,"Not Eligible","Eligible")
Best regards