Results 1 to 4 of 4

Order of 3 numbers in a non ordered range

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    brazil
    MS-Off Ver
    Excel 2007
    Posts
    64

    Order of 3 numbers in a non ordered range

    I need some help.

    I have to find the order which 3 numbers (C2, C3 and C4) occurs in a non ordered range.

    See attached file.

    The question is that the match is not exact, it varies from -2 to +2 over C2, C3 and C4, like:
    AND(>(C2-2);<(C2+2)).

    In E2 I need to know the first number that appears on the range A2:A15, then in E3 the second and in E4 the third.

    The formula that make some sense (even if they don't work):
    =INDEX(A2:A15,MATCH(C2,AND(A2:A15>C3-2,A2:A15<C3+2),0),1)
    =INDIRECT("A"&MATCH(AND(>C2-2,<C2+2),A2:A15,0))

    Please, I'm really dazed!
    Attached Files Attached Files
    Last edited by dualaudio454252; 02-12-2014 at 10:42 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 04-01-2013, 08:19 AM
  2. Is it possible to count some numbers in a range(Descending order range)
    By amitgurus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2013, 10:59 AM
  3. Is it possible to count some numbers in a range(Descending order range)
    By amitgurus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2013, 08:41 AM
  4. [SOLVED] How do you apply the int() in VBA in order to convert numbers stored as text to numbers
    By djaurit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2012, 02:57 PM
  5. Replies: 3
    Last Post: 10-21-2005, 01:05 AM

Tags for this Thread

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