Counts min and max quantity of equals 'strings' based on a filter column

[June7]

Aussie, I tried suggestion.

The unique list repeats the 000001 value.

The SMALL() results are not correct.

The LARGE results are correct but I don't think would always be the case. Because, as far as I can tell, these formulas do not take into account grouping defined by H column.

Correction, I do have COUNTIFS available (still not MINIF, MINIFS, MAXIF, MAXIFS). Just not sure it can be helpful.

This does work.

On each row K9:K70, calculate: =COUNTIF($J$9:$J$70,J9)

Then 4 array formulas:

{=MIN(IF($H$9:$H$70=1,$K$9:$K$70))}
{=MAX(IF($H$9:$H$70=1,$K$9:$K$70))}
{=MIN(IF($H$9:$H$70=2,$K$9:$K$70))}
{=MAX(IF($H$9:$H$70=2,$K$9:$K$70))}

Simpler than I expected. You probably have MINIF and MAXIF available.