| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count with multiple criteria / combination
What formula or macro can I use to get the following information?
From two columns of information I need to find out how many times a certain combination occurs for example: Text in colums A1:A22 and B1:B22 will be a mixture of "spade", "heart", "club", "diamond" so I need to find out if what the combinations per row are i.e: A1 = heart B1 = spade A2 = heart B2 = heart A3 = heart A3 = spade So: heart / spade combination = twice heart / heart combination = once Help please...... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
| To count the data using multiple criteria in multiple columns | New Users to Excel | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| COUNT WITH MULTIPLE CRITERIA | Excel Worksheet Functions | |||
![Eán[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
