jvanworthkhsd
Board Regular
 Joined
 Sep 26, 2008
 Messages
 78
 Office Version

 365
 Platform

 Windows
I have course list from Col B to Col E for Students (col A):
A B C D E F
Name Per 1 Per 2 Per 3 Per 4 Math
John Algebra English 9 PE Art Algerba
Pollete English 10 Con Math Biology PE Con Math
Chris Art PE Algerba 2 English 9 Algerbra2
in column F I want to list any math course that matches up to a list of math courses...ie:
Algebra
Gen Math
Con Math
Geomerty
Algebra 2
I cannot come up with a match formula that will work. Any ideas
A B C D E F
Name Per 1 Per 2 Per 3 Per 4 Math
John Algebra English 9 PE Art Algerba
Pollete English 10 Con Math Biology PE Con Math
Chris Art PE Algerba 2 English 9 Algerbra2
in column F I want to list any math course that matches up to a list of math courses...ie:
Algebra
Gen Math
Con Math
Geomerty
Algebra 2
I cannot come up with a match formula that will work. Any ideas