1x2

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I need a formula in the row 13,14,15 which can find unique character from row 6,7,8 and show result in order as 1X2 in the rows 13,14 and 15 </SPAN></SPAN> Resulting data...</SPAN></SPAN>...

Using Excel 2000 Hi, I want to find among each row in C:F column what is unique or missing, results in the coloums H:I Example data <colgroup><col><col span="2"><col span="4"><col><col span="2"><col></colgroup><tbody> A B C D E F G H I J 1 2 3...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Data cells C6:C78, highlighted every 7th row with black background-white fonts, my query is I need to check cycle for 3 characters 1X2 when it is completed.</SPAN></SPAN> For the example...</SPAN></SPAN> C6=X, C13=1, C20=2, so far cycle of...

Using Excel 2000 Hi, I want VBA the could generate "set of 14" out of "3-digits" My 3-digit set is in the A2:A4 consists of "1X2" In the cells A6:A45 filled number 1 to 40 this mean I need 40 random sets or it can be asked via input "how many set required" First "set of 14" is...

Using Excel 2000 Hi, I am looking VBA that can count 3 diagonals signs "1X2" if the are same then result = 1, if 2 are same 1 is different then result = 2, if 3 are different then result = 3 Step1-Start looking diagonal "1X2" signs in C6, D7, and E8 Find 1, 1, 2 Result 2 in T9 Step2-Start...

Using Excel 2000 Hi, Data in cells C6:I80 require result "counts for completed cycle" in column K Cycle of 3 characters "1X2" for example... If cycle start with "1" has to finish with "X or 2" If cycle start with "X" has to finish with "1 or 2" If cycle start with "2" has to finish with...

Using Excel 2000 Hi, Count if 3 character "1 X 2" are find in the 3 rows no matter the if they are not in sequence (I mean can be "1X2", "X12", "2X1" or in any sequence no problem) Data are in cells C6:I80 (count results in K6:K80 Look "1X2" into 3 rows STARTING FROM C6 for example...

Using Excel 2000 Hi, I need a macro, which look cycle for "1X2" within 4 rounds if not found go to next row and search within 4 next rounds Data are in cells C6:C82 Step1-code start searching cycle for "1X2" in cells C6:C9 if cycle for "1X2" does not find continue to step-2 Setp-2 go to...

Hi guys! I have two columns with values. The first column contains personal bets in a standard 1x2 system for betting. The second column contains results of the games. The third column contains points awarded for correct betting. Betting Game Result Points awarded 1x 1 2...