On Jul 30, 10:37*pm, robzrob wrote:
On Jul 30, 10:26*pm, Emily wrote:

Hi everyone,

Column B contains a list of text data, which happens to be numbers (e.g..
1172, 4721, 6743, etc.). Every time I enter a new number in the column, I
would like another column in the same row to check the previous entries in
column B and report whether the exact same number has been entered before (if
true="yes", if false="no").

It seems simple, and reading previous posts on similar subjects has left me
totally confused. I tried an IF function but didn't get very far.

-Grateful newbie

In col C: =IF(COUNTIF(B:B,B1)1,"YES","NO")

...then copy down - sorry.