If, then
 

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.

If, then
 

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.

If, then
 

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.

If, then
 

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.

If, then
 

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.

If, then
 

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