Hi,
How do i get my excel to compare between tables and come up with a result. For example i have 2 tables,
Table 1
Table 2![]()
Class A| Class B| Class C| Class D James Alice Tim Dan Sam
How do i make them compare and then come up with a result like![]()
Attended James Class A Class B Alice Class C Dan Class D Sam Class A Tim Class C
![]()
Class A| Class B| Class C| Class D James X X Alice X Tim Dan X Sam X
Bookmarks