Excel Forum



Excel Magic Trick 635: Find Perfect Match In Column Using IF & AND functions


See how to find a perfect match of 6 successive items using the AND and IF functions in two formulas:
1) Non-array formula
2) Array formula (much shorter and better formula, but requires Ctrl + Shift + Enter).





Got a Question? Ask it Here in the Forum.