| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need formula to pull for class roster
I have the following list - over 100 rows with 20+ columns of data --
I need a formula that will give me the data in a separate worksheet by teacher name-subject with Lname Fname of student. ANY help would be GREATLY appreciated -- Here is an example of what I have to deal with -- LNAME FNAME Mon 1 Mon 2 Mon 3 1st Block 2nd Block 3rd Block Aguilar Alicia Crumpton-LA Kerns-Math Stone-Sci Black Delancius Kerns-Math Stone-Sci Crumpton-LA Brant Chasity Kerns-Math Stone-Sci Crumpton-LA Britton Jannie Stone-Sci Kerns-Math Crumpton-LA I would like for it to come out like this -- LName FName Mon1 Black Delancius Kerns-Math Brant Chasity Kerns-Math ETC... One teacher with all of her students listed -- THANKS Confused |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is anyone familiar with the pull formula in excel? | Excel Worksheet Functions | |||
| formula to pull name and amount | Excel Worksheet Functions | |||
| Unable to set the formula property of the series class | Charts and Charting in Excel | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| I need a formula that adds up "L" (lates to a class) over E4 to Q. | Excel Worksheet Functions | |||
Threaded Mode
