detect, the double, frontal or rear, according to the 6 letters .

jack

Member
detect, the double, frontal or rear, according to the 6 letters
in the 6 letters we have 6 conditions of pairs, sometimes we have double in two, letters, mark the two letters
* The binary = is to find the front and back pair
http://www.mediafire.com/file/y18r86...ck_3.xlsx/file
 

jack

Member
we will forget the 59, we will only focus on the front pair in case 15
* let's just work with front pair
* example 457 only the 45, forget the back pair ok
next step = good 6 types of pairs or 6 groups with letters
you can separate the initial pair and then locate in which group that was represented.
159 15 = B
457 45 = F
852 85 = 0
963 96 = 0
note that the pairs 85 and 96 do not belong to neither of the 6 groups, when this happens it assigns the value 0 (zero)
* let's use only the front pair
 

jack

Member
we have a list of paired or double conditions
* you can see the presence involving, front or rear pairs
* of the pick3, each letter will be where the double
objective = is to locate the front or rear pairs of the pick3
* with the list of 6 types of pairs according to the letter group, please
 

jack

Member
=IF(OR(VLOOKUP(($A5*10)+$B5,CrossRef,2,FALSE)=$E$4,VLOOKUP(($B5*10)+$C5,CrossRef,2,FALSE)=$E$4),"X","")
 

Sidebar

Top