| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create list of text matching criteria
I am working with a project status report where the first two columns in the
worksheet are Project Status, Project Name. On another worksheet, in columns (by status) I have a set of simple counts of each status. Easy enough. Below each of the counts by status, I would like to create a list of all the projects in that particular status. I've messed around with VLOOKUPS but can only find the first value in the range matching the criteria. I've also messed around with vlookups in an IF statement, but still can't figure out how to do this. Does anyone have ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching Lists Where List Size is Unequal | Excel Discussion (Misc queries) | |||
| Copy # fm one list to matching id in list 2? | Excel Worksheet Functions | |||
| Create A List From A List | Excel Worksheet Functions | |||
| Extract multiple records matching criteria from list | Excel Worksheet Functions | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
