| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching 2 Text fields
Two sheet, identical except for the test and test results.
"Sheeloo" wrote: How many sheets do you have? One sheet has Student and his grade? Others Student, Test, Result? Do you have a list of all students? Does Student col has any duplicate values? -- If you find this post helpful pl. choose "Yes"... "Sprowler" wrote: I have a data base in excel that lists test info on students. There are multiple tests on various sheets. The sheets are almost identical except for the test being different and thus the results. How do I combine the sheets into one sheet, that will have the student's name lined up on one continuous line? I can then delete the columns that are duplicated but have the test info on one line. Student, grade, test a, result Then on another spread sheet the info is the same but the test is different info is different. I am looking for: student, grade, test a, result, test b, result. I think this can be done but I need some help please. Thank you in advance. Susan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail merge matching fields | Excel Discussion (Misc queries) | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| matching fields between two workbooks | Excel Worksheet Functions | |||
| matching key fields between two workbooks and displaying info when | Excel Worksheet Functions | |||
| matching multiples fields in 1 row | Excel Worksheet Functions | |||
Threaded Mode
