| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
list, search, and display
Try AutoFilter
"Richard" wrote: Name Test Grade RACE Peter 89 B BLACK Jason 74 C WHITE Tom 98 A ASIAN John 56 F WHITE Susan 86 B WHITE Michelle 94 A ASIAN Paula 78 C WHITE Janet 86 B BLACK Mike 67 F BLACK Ben 78 C WHITE The above is example sheet for my question. Assuming that name is from cell A2:A11, and point is from cell B2:B11, and grade is from cell C2:C11, and race is from cell D2:D11.Now, I create a list for grades from A to F. When I select a drop down list and select A, I want to display 2 or all students that got an A and their race. The result would be similar to the one below: Find Grade: A Name Race Tom Asian Michelle Asian What is the formula for that 2 or more students that got an A or other grades when I select from the list? Can this be possible in excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list, search, and display | New Users to Excel | |||
| search and display | Excel Discussion (Misc queries) | |||
| Search multiple columns and display corresponding cells in a list?!? | Excel Discussion (Misc queries) | |||
| Search and Display Formula | Excel Discussion (Misc queries) | |||
| Search and Display Sheet Name | Excel Discussion (Misc queries) | |||
Threaded Mode
