In Column B I will enter account numbers.
In Column D I want the number of attempt I made to contact the account (1,
2, 3, 4, 5, etc).

If the account number is not within Column B, Then D populates 1 (first
attempt)
If the account number shows twice within Column B, Then D populates 2
(second attempt)
If the account numbers shows three times within Column B, Then D populates 2
(third attempt)
Etc.