+ Reply to Thread
Results 1 to 5 of 5

Find double numbers function...

  1. #1
    stewart08
    Guest

    Find double numbers function...

    Dear excellers,
    being trying to figure out-all day this simple function:

    I have 10 numbers each from 1-50 i.e.

    7,11,33,33,9,9,12,8,12,11

    I need a function which list all 4 double numbers.

    result should be: 9,33,12,11

    I tryed everything and still cannot get it to work please help

    PS 10 cells for the 10 numbers list and 3 cells for the first 4 doubles.
    Last edited by stewart08; 11-18-2008 at 05:12 PM.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Find double numbers function...

    With
    A2:J2 containing numbers

    This ARRAY FORMULA, committed with CTRL SHIFT ENTER
    (instead of just ENTER) returns the 1st instance of a duplicated number:
    Please Login or Register  to view this content.
    Copy I2 and paste into J2:T2 to complete the list of duplicated values.

    In your example, the formulas return these values (in the order encountered):
    I2: 11
    J2: 33
    K2: 9
    L2: 12
    M2: (blank)

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    stewart08
    Guest

    find doubles

    thanks for your time replying...but I still cannot get it to work!

    see screen shot
    what I need is 4 returned doubles finded from 10 numbers:
    http://www.graphic-elite.com/figure.jpg

    result
    when I use your formula it finds the first double but not on the second! and also I donot what know what this blue index box does it needs to be all horizon. I think I donot use it correctly:
    http://www.graphic-elite.com/figure2.jpg
    Last edited by stewart08; 11-19-2008 at 09:47 AM.

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Find double numbers function...

    I suspect you are not committing the formulas with CTRL+SHIFT+ENTER.
    The attached workbook demonstrates how the formulas work.

    Does that help?
    Post back with more questions.
    Attached Files Attached Files

  5. #5
    stewart08
    Guest
    Ron, I just got it working from the attached file wow.

    thank you for you time and help Ron Coderre... this forum is one of the best ever

    I have another function that needs your help will post it some...

    thanks again

+ 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