+ Reply to Thread
Results 1 to 3 of 3

Easy formula, needs help please...

  1. #1
    stewart08
    Guest

    Easy formula, needs help please...

    This should be a easy formula but I can't seem to figure it out, as follows. The formula has two criteria:
    1) the match range (array of numbers) to find matches can be chosen
    2) with in that array of numbers, the largest number of match is listed i.e. 1,2 or 3.

    to help here's a example:

    closes match to 173

    search 3 number sets

    564 < 0 matches
    238 < 1 matches
    732 < 2 matches
    568

    result should be 173 = 2

    (7 & 3 was the largest number of matchs find)

    keep in mind the formula needs to find matches in 'hold number sets' if possible i.e. "732" and in a un-ordered nature i.e. match 563 via 568 586 658 685 856 865 = 2 matches.
    if 3 matches are found i.e. 563 via 563 536 653 635 356 365 then that is chosen instead as being the largest...
    Last edited by stewart08; 04-16-2008 at 07:19 AM.

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    Using what I gave you last time, in D1, =COUNTIF(B$1:B$1000,C1) and drag down as far as you need. Adjust your range as necessary.

  3. #3
    stewart08
    Guest
    darkyam, again this fine to find exact matches i.e. 573 > 573 = 1
    but I need to find un-order matches i.e. 573 > 735 = 3

    remember I need to find number of matches from say 573 > 637 = 2 or 573 > 639 = 1

    and with chosen range say only look in the next 3 sets of numbers example

    679 < search
    010 < search
    642 < search
    468
    421

    648 = 1

    sorry but the formula has many criteria to follow...if this can be do with digits in each cell then I will use that solution.
    Last edited by stewart08; 04-16-2008 at 08:18 AM.

+ 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