Please see attached excel file.
On the sheet names INPUT SHEET, i have a table with student names and their respected groups along with columns of points grouped in months.
below this is a results sheet which i want to produce which will display all students' points from a selected group from a selected month.
for example, i want to display all students (names and points) in group GREEN in the month FEB.
ive used the Index and Match functions however this only works for the first student. it doesnt display All students in that particular group...
how can i achieve this please?
thanks
Bookmarks