If, then

L

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.
 
L

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.
 
Top