find doubles in number group!

[stewart08]

Hi excelers

I also have another problem or puzzle that needs help:

I have 24 four digits from A1 to X1 i.e. 9584 9520 9674 9629...etc
would any one know a simple formula that can found any doubles and indicate as howmany in A2 as number of doubles...

And remember "1234" and "1243" should be indicated as a double = 1

example of digits:

9584 9520 9674 9629 9070 9089 3184 3120 3634 3625 3030 3085 4174 4129 4534 4525 4039 4075 8170 8189 8530 8585 8639 8675

[martindwilson]

install the more functions add in

http://www.download.com/Morefunc/300...-10423159.html

then in a2 array entered (with ctrl shift enter) and dragged across
=MCONCAT(SMALL(MID(A1,INTVECTOR(LEN(A1),1),1)+0,INTVECTOR(LEN(A1),1)))

then in a3
=IF(COUNTIF($A$2:$X$2,A2)>1,"true","false") again dragged across

[stewart08]

I enter it but will not work see figure:

\1

what am I dioing worry I install morefuc and used ctrl shift enter?

[martindwilson]

your image doesn't show { } around the formula which are put there when you use ctrl shift enter,hold down ctrl and shift together and while still down press enter (CSE)
you must click on the formula in the formula bar not the cell when you do it. see attached for working example

[stewart08]

martindwilson after check out your attach example sheet it noe works.

big thanks 100%