Main Profile

At A Glance

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 formula2) Array formula (much shorter and better formula, but requires Ctrl + Shift + Enter).
Length: 04:09

Contact

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

Want more info about Excel Magic Trick 635: Find Perfect Match In Column Using IF & AND functions? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question