| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions (search within search result)
I am trying to search within a search result to give me a particular result
Refer "desired result" below. For example, from a group of 3 students, 3 tests were given. I would like to search each student by Student ID and for that particular Student, I would like to show the score for one of the tests. Can anyone assist me in using functions to do this? Data: Sudent Test Score Student1 Econ 12 Student1 English 41 Student1 Math 21 Student2 Econ 11 Student2 English 23 Student2 Math 12 Student3 Econ 22 Student3 English 44 Student3 Math 41 Desired Result: Student Test Score Student1 English 41 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search 2 Criteria for 1 sep result | Excel Discussion (Misc queries) | |||
| Please help on array search & result | Excel Worksheet Functions | |||
| filtering based on a search result | New Users to Excel | |||
| select cells that are the result of a search | Excel Discussion (Misc queries) | |||
| SEARCH function #VALUE! result | Excel Worksheet Functions | |||
Threaded Mode
