I tried several times. Cannot get your calcs to work. First two rows in the distinct list are 000001. Change the data a bit and even the Large() calcs will not return correct values because not considering the grouping of column H.


As far as I can tell, values do not duplicate between the H groups, however, could allow for that with: =COUNTIFS($H$9:$H$70,H9,$J$9:$J$70,J9)