Excel Forum
Similar Content
How to Add, Remove, and Rearrange Columns and Rows in Excel
Tutorial: Adding, removing and rearranging columns is as easy as resizing. You just select your colu...
SUMIF - Sum Values Based on Criteria in Excel
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.