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...![]()
Bookmarks