pitterpitter
MIS
I have a main class roster listing all students in one column and which class they took (1-6) in another column. Then I have a separate worksheet of each of the 6 classes. I want to be able to take all students from each class listed in the main roster and automatically populate the corresponding worksheets with the students name, etc. My IF formula does this but leaves blank lines on the rows where the result is false. How do I eliminate the blank lines? Here is the formula. Thanks so much for your help. I haven't used Excel in a while and my mind has just gone blank.
=IF('Main Roster'!G9="X", 'Main Roster'!B9, "")
=IF('Main Roster'!G9="X", 'Main Roster'!B9, "")