Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctinos,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
list, search, and display
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 | |||
SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW | Excel Worksheet Functions | |||
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) |