Recent content by sana1

Thanks for the solution. This would work. But I have more than 12 criterias out of which 3 are flexible criteria (# might go up in future). In this case the match formula would become very complicated and in case of changes it will become very cumbersome. Is it possible to have a macro or a...

Thanks for responding. Here are the answers: 1) Each of these courses are unique. So, no two courses will have the same combination 2) It is a one to many mapping. One course can be mapped to multiple students, vice versa is not true (# of courses are lesser than # of students). 'What I...

I have two sets of data X (Course) and Y (Student). X shows the list of courses available with 4 criterias which define a course. Y shows the list of students with the same criterias. Data X DATA X 1 2 3 4 A Y N Y Y B N Y Y Y C N N Y N D Y Y Y Y E Y Y N N Data Y DATA Y 1 2 3 4 a Y Y...