L
lynn
I apologize in advance if this topic has been covered (I
know it has been because I asked the same question a few
months ago, but forgot how to do it! ) but I need a way to
find duplicate entries in a column. For instance, I have a
column of Invoice numbers, and I want to make sure that no
one entered the same invoice twice. I believe this
involved a formula in the column next to it which returned
the word "Duplicate" (or whatever I use in the formula)
for each occurance of a duplicate entry.
Using Excel 2000 or 2002...
know it has been because I asked the same question a few
months ago, but forgot how to do it! ) but I need a way to
find duplicate entries in a column. For instance, I have a
column of Invoice numbers, and I want to make sure that no
one entered the same invoice twice. I believe this
involved a formula in the column next to it which returned
the word "Duplicate" (or whatever I use in the formula)
for each occurance of a duplicate entry.
Using Excel 2000 or 2002...