|
Featured Tutorial
Featured Macro
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.