I try to generate the list based on a criteria: if the "name" on the first column = "George" (for example), display a list with subjects he/she attended and for how many hours and if he/she attended the same subjects display it only once and sum the hours.
What is colored in yellow is manually entered, just to show you what I want to accomplish.
I tried with a combination of IFERROR, INDEX, and SMALL functions but it doesn't work. Any help will be appreciated!
Bookmarks