I have a list of terms in Col D.
I would like a distinct list in Col F and in Col G I would like a count of the distinct terms displayed in Col F from Col D.

For Col F I am currently using the following formula and it is working great.
=IFERROR(INDEX($D$2:$D$2000, MATCH(0,COUNTIF($F$1:F1, $D$2:$D$2000), 0)),"")
Any suggestions on this?

I am unsure what to do about Col G.
I have this, but it isn't working.
=SUM(--(FREQUENCY(IF($D$2:$D$2000=F2,MATCH($D$2:$D$2000,$D$2:$D$2000,0)),ROW(D2:D2000)-ROW(D2)+1)>0))

Thoughts, ideas and musings welcomed.
excel.PNG