Dup entry two colums
The easiest way is to concatenate the two fields together in a new column.
Then you can use a simple count function to indicate how many of each item
that you have. Do a filter excluding 1 and you have all of your duplicates...
--
HTH...
Jim Thomlinson
"pgarcia" wrote:
Hello all,
I have two colums, one hads check number and the other has dollar amounts.
How can I find dup by first look at the check number then by dollar amount?
|