+ Reply to Thread
Results 1 to 5 of 5

find doubles in number group!

  1. #1
    stewart08
    Guest

    find doubles in number group!

    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
    Last edited by VBA Noob; 02-17-2009 at 07:01 PM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: find doubles in number group!!!

    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
    Last edited by martindwilson; 02-17-2009 at 07:58 PM.

  3. #3
    stewart08
    Guest

    Re: find doubles in number group!

    I enter it but will not work see figure:

    \1

    what am I dioing worry I install morefuc and used ctrl shift enter?
    Last edited by stewart08; 02-18-2009 at 12:45 PM.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: find doubles in number group!

    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
    Last edited by martindwilson; 02-18-2009 at 02:19 PM.

  5. #5
    stewart08
    Guest

    Thumbs up Re: find doubles in number group!

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

    big thanks 100%

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1