Perhaps you meant ..
In D2, copied down: =COUNTIF(B:B,B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LiveUser" wrote:
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.