TK, someone will no doubt post a formula I would imagine. I might mention
that the ASAP Utility that is free to download has a "count duplicates in
selection" where it will color code any dupes. It is under the ASAP
"Information" heading. Google for ASAP Utility and take a look. I have no
affiliation with them, but I use it for a number of interesting little
utilities like this.

If you need a permanent column for your batch data, I guess you'd need to
solve it formulaically. But...

Cheers! Brad (in Texas)


"TKnTexas" wrote in message
oups.com...
I am entering data to column B, a 5-digit number. Is there a formula
that I can put in column D that will tell me if the number is a
duplicate. The numbers batch numbers from the accounting system.
There should be only one. But since I am entering the batchs with them
unsorted, I was curious if a formula could check.

TK