demonfootball21
New Member
- Joined
- Sep 7, 2011
- Messages
- 14
If(ISERROR(Search function I am doing.
on one sheet that I am emailed(that i can not change) looks like this(Failing_Kids!)
A B C
Last First Subject
it populates each class on one line. Even if the same kid is failing multiple classes
4)Smith Jon English
5)Sanders Bill Math
6)Johnson Harrison Math
7)Johnson Harrison English
on my other spread sheet(Final!) for columns A and B i have a =Failing_Kids!A4 so on my new sheet it pulls Smith Jon real simple there.
then for columns B - K I have the classes as headings
English Math Social Studies(etc)
this is in row 4 that matches the kid from Failing_Kids!) with a formua of =IF(ISERROR(SEARCH("*English*",Failing_Kids!D4,1)),IF(ISERROR(SEARCH("*Literacy*",Failing_Kids!D4,1)),"","English"),"X").....then in column D same code just with "MAth".. "Geometry" etc
As not all English classes are classed English I have to have multiple entries. Thats the easy part! Since I'm just pulling from D4 if it says English or literacyin D4 it puts an X in column C. If its Math There is an X in D.
The problem is when there are multiple classes for the same kid like I showed in Johnson.
Right now i am getting D6 and D7 to populate perfectly on two seperate lines, but I'd like D7 to populate on the same line as D6. So it has two Xs, one in the Math column and one in the english column for Johnson. so i Can look straight across and see he is failing two classes not just one and then have to look at the next row to see its him again.
Any ideas or videos I can watch?!
on one sheet that I am emailed(that i can not change) looks like this(Failing_Kids!)
A B C
Last First Subject
it populates each class on one line. Even if the same kid is failing multiple classes
4)Smith Jon English
5)Sanders Bill Math
6)Johnson Harrison Math
7)Johnson Harrison English
on my other spread sheet(Final!) for columns A and B i have a =Failing_Kids!A4 so on my new sheet it pulls Smith Jon real simple there.
then for columns B - K I have the classes as headings
English Math Social Studies(etc)
this is in row 4 that matches the kid from Failing_Kids!) with a formua of =IF(ISERROR(SEARCH("*English*",Failing_Kids!D4,1)),IF(ISERROR(SEARCH("*Literacy*",Failing_Kids!D4,1)),"","English"),"X").....then in column D same code just with "MAth".. "Geometry" etc
As not all English classes are classed English I have to have multiple entries. Thats the easy part! Since I'm just pulling from D4 if it says English or literacyin D4 it puts an X in column C. If its Math There is an X in D.
The problem is when there are multiple classes for the same kid like I showed in Johnson.
Right now i am getting D6 and D7 to populate perfectly on two seperate lines, but I'd like D7 to populate on the same line as D6. So it has two Xs, one in the Math column and one in the english column for Johnson. so i Can look straight across and see he is failing two classes not just one and then have to look at the next row to see its him again.
Any ideas or videos I can watch?!
