So I thought I asked this question but I may have forgot to hit submit on the topic before closing the browser.
So in the attached sample file I give an example of a typical student and the multitude of Academic Plans they could have along with Sub-Plans. What I want to be able to do is count the number of students that by the Plan or Sub-Plan name. So if the student has something in Column C through Column AF I want to count it by what it is specifically.
So my ideal visual output would be the following where the Plan and Sub Plan are listed regardless of whether it is 1, 2, 3, 4, 5, etc and the count of unique student that has that program listed for them.
The one complication is that there is no guarantee that the columns will always be Column C through AF. So is there a way to create a formula that says if the column has this name in a series of IF statements so I catch all applicable columns?
Sample File for EDNA.xlsx (8.4 KB)