Excel Forum

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.

Got a Question? Ask it Here in the Forum.