if i have the following columa

aa 111
bb 222
aa
cc 333
dd 444
aa
aa 321
cc
cc

from above if it huag data and i want ensuar that all aa have same key
account whuch 111 and other key account and if aa has more than one key
account it show wrong or any thing like B7 it has wrong key which 321
how i cank make it by excel

Hi,

How do you know if the first or second key is wrong? Here is a formula that
will tell you which items don't match. Anytime this returns a number greater
than 0 there is a problem.

=IF(B1="","",SUMPRODUCT((A1=$A$1:$A$9)*(B1<$B$1:$ B$9)*($B$1:$B$9<"")))


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"M.K" wrote:

if i have the following columa

aa 111
bb 222
aa
cc 333
dd 444
aa
aa 321
cc
cc

from above if it huag data and i want ensuar that all aa have same key
account whuch 111 and other key account and if aa has more than one key
account it show wrong or any thing like B7 it has wrong key which 321
how i cank make it by excel