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.

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.

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" wrote:

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.

Think you could use this slightly revised ver:
In D2, copied down: =COUNTIF(B$2:B2,B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LiveUser" wrote:
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.

This works Thank you.

"Max" wrote:

Think you could use this slightly revised ver:
In D2, copied down: =COUNTIF(B$2:B2,B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LiveUser" wrote:
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.

Welcome, good to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LiveUser" wrote in message
...
This works Thank you.