Forum Discussion
GJG
Dec 09, 2020Copper Contributor
INDEX/MATCH using 2 criteria, and returning Nth value of INDEX/MATCH with 2 criteria
Hello, I have a table in which people are assigned an amount of time to a task (in this case, teaching a course). The first table is organized by person; their name repeat in column A, with cour...
Detlef_Lewin
Dec 09, 2020Silver Contributor
Either with a data model pivot table and a measure with CONCATENATEX() or with dynamic array formulas.