Try, in E2:
Formula: copy to clipboard
=COUNTIF(A:A,D2)


If that is a Table, it should AutoFill. If not, just copy down.