Dup entry two colums
Thanks, I found that after I posted this.
thanks
"MartinW" wrote:
Hi,
Assuming your data is in A1:B100
put this in C1 and drag down
=SUMPRODUCT(($A$1:$A$100=A1)*($B$1:$B$100=B1))
adjust the ranges to suit
Any return greater than 1 will be a duplicate.
HTH
Martin
"pgarcia" wrote in message
...
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?
|