| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return matching names per criteria in table
Hi there,
I have a table 154 rows (name) by 31 columns (criteria). There are 220 possible criteria, but one name cannot have more than 30. I would like to list the names each criteria uses. For example, criteria #1 might be used by 7 different names, and this can be found simply with "=COUNTIF(range,"criteria #1")". What this does not give is the names that are used, merely the number of names that use it. I suspect I will need a macro, but have no idea how to start. Any ideas please? Thanks, Ewan. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Data Matching Criteria in a separate spreadsheet | Excel Worksheet Functions | |||
| search worksheets in same book to return value matching criteria? | Excel Worksheet Functions | |||
| I want to use a link to return all data matching a criteria | Excel Worksheet Functions | |||
| Sorting and Matching criteria across rows to return a result in the last cell | Excel Worksheet Functions | |||
| Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions | |||
Hybrid Mode
