If, then

[LiveUser]

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.

 

[Max]

Perhaps you meant ..
In D2, copied down: =COUNTIF(B:B,B2)

 

[LiveUser]

Max,

Thanks for the response, but if I did it that way, then I would never have a
good way to track which one was the first attempt, second attempt, and third
attempt (by specific number)... in someway. Your way would update all of the
attempts. So the first attempt would change to the second attempt and the
second attempt would be second attempt. Two second attempts.

 

[Max]

Think you could use this slightly revised ver:
In D2, copied down: =COUNTIF(B$2:B2,B2)

 

[LiveUser]

This works Thank you.

Think you could use this slightly revised ver:
In D2, copied down: =COUNTIF(B$2:B2,B2)

 

[Max]

Welcome, good to hear that.