Hi Rich,

applied to your sample data, this formula in F7

=IF(ISTEXT(INDEX(C7:C15,MATCH(0,COUNTIF($F$6:F6,C7:C15),0))),INDEX(C7:C15,MATCH(0,COUNTIF($F$6:F6,C7:C15),0)),0)
This is an array formula and must be confirmed with Ctrl-Shift-Enter. Then copy down to F15.

This formula in G7, copy down:
=IF(F7<>0,COUNTIF(C7:C15,F7),"")