Count Hierarchies without including dupes
Is it possible to count the number of the hierarchies?
Right now, I'm using the count function and manually clicking on level 1 for those counts and level 2 for those counts. My document is rather large and I don't want to click through each one and someone may insert a new level and I don't want a break in my formula.
The formula I used for level 2 that counts the total number of students is as follows:
=COUNT([Placement ID]2, [Placement ID]5, [Placement ID]8, [Placement ID]10, [Placement ID]13)
I didn't use the count column because I don't want to count everything there since there are dupes and I need a true count of the students. Each student can have 1-3 assignments which is why you see the dupes. I just want to count the level which will give me 5 students and not 15.
I hope my example makes sense.
The info is fictitious but my sheet has the same layout and I need to be able to count the cohorts and individual students, not dupes.
Any assistance is greatly appreciated.