Display distinct values and their counts

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

I might be oversimplifying and/or missing what you are asking but in cell G2, can you not use =COUNTIF(D:D,$F2)? Copy & paste down as needed...

You are exactly correct omccabe!
Apparently the first formula drained my brain and something like this was just beyond me. Thanks so much!