Need formula to pull for class roster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Working Teacher - 17 Mar 2008 22:16 GMT

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

Reply to this Message

Michael M - 17 Mar 2008 22:56 GMT

Hi confused
Simple method is to do a data sort for the column you require and copy and
paste the results into your new sheet.
Another method is to record a macro of the above tasks and then you can run
it anytime you need it.

HTH
Michael M

> I have the following list - over 100 rows with 20+ columns of data --
>
[quoted text clipped - 22 lines]
> THANKS
> Confused

Reply to this Message