Main Profile

At A Glance

Excel Magic Trick 368: Count Unique Items With More Than One Criteria

Amazing use of the FREQUENCY and MATCH functions! Array formula for counting unique items in a column with criteria in a second column. See 1 formula for counting numbers and 1 for counting words. Formulas use the functions: SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER in an unusual combination. Formula from Mr Excel Message Board.
Length: 14:02

Contact

Questions about Excel Magic Trick 368: Count Unique Items With More Than One Criteria

Want more info about Excel Magic Trick 368: Count Unique Items With More Than One Criteria? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question