Hi

I understand this formula search if all 11 numbers repeat more that
once ,but i need to know only 7 numbers or 6 numbers not 11 .....

Let say i have in A1=2 B1=5 C1=6 .................K1=11
A1=2 repeat in B18=2 and C1=6 repeat in D18=4


--
laly
------------------------------------------------------------------------
laly's Profile: http://www.excelforum.com/member.php...o&userid=27303
View this thread: http://www.excelforum.com/showthread...hreadid=471238