W
Wilma
I am trying to link data from one worksheet to another using the IF formula.
The first worksheet (roster) includes student information, status (active or
inactive) and assessment units completed (designated as Y or N for each
unit). The subsequent worsheets include the data for each unit.
With the help of Max--I used the following formula in the second worksheet
to return a value only if the student was active and had completed the unit:
=IF(Roster!$A9="I","",IF(AND(Roster!$A9="A",Roster!$H9="Y"),Roster!B9,""))
However, if a student is inactive (I) --a blank cell is returned. Is there
any way for the values of only the active students (A) to appear on the
worksheet sequentialy (without the blank cells)?
Your help is greatly appreciated!
The first worksheet (roster) includes student information, status (active or
inactive) and assessment units completed (designated as Y or N for each
unit). The subsequent worsheets include the data for each unit.
With the help of Max--I used the following formula in the second worksheet
to return a value only if the student was active and had completed the unit:
=IF(Roster!$A9="I","",IF(AND(Roster!$A9="A",Roster!$H9="Y"),Roster!B9,""))
However, if a student is inactive (I) --a blank cell is returned. Is there
any way for the values of only the active students (A) to appear on the
worksheet sequentialy (without the blank cells)?
Your help is greatly appreciated!