| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List of Qualifying Values
I have a list of Data as follows (commas indicate a new column)
Name, Region, Subject Area1, Subject Area 2, Subject Area 3 Under each of the Subject areas is a value (1-4) that indicates this persons ability. Is there a way that I can an automated list for each of the subject areas that shows all individuals that are above a certain level (ie 3-4): Subject Area 2: Name, Region, 4 Name, Region. 4 Name, Region, 3 Vlookup can only return the first individual. Thank you for any help you can give! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Characters Qualifying a formula | Excel Discussion (Misc queries) | |||
| Qualifying a generated value as unique across worksheets | Excel Discussion (Misc queries) | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| copy qualifying rows to another spreadsheet | Excel Worksheet Functions | |||
Threaded Mode
