CRodrigues Posted January 28, 2015 Share Posted January 28, 2015 Ausentes 1164: 01 05 08 11 12 15 16 17 20 2401 02 05 09 12 13 14 15 17 19 Quote Link to comment Share on other sites More sharing options...
Bigode Posted January 29, 2015 Share Posted January 29, 2015 10 Ausentes Conc. 1164 [ 01 08 09 11 14 16 17 18 20 21 ][ 05 07 10 12 13 17 18 19 21 24 ] Quote Link to comment Share on other sites More sharing options...
AIRTON MIRANDA Posted January 29, 2015 Share Posted January 29, 2015 Alô! amigos. Obrigado aos 04 participantes. 1- CRodrigues................. 06 ausentes.2- Bigode..................... 05 ausentes.2- Álvaro César............... 05 ausentes.3- Titus...................... 03 ausentes.3- Airton..................... 03 ausentes. Quote Link to comment Share on other sites More sharing options...
Álvaro César Posted January 29, 2015 Share Posted January 29, 2015 116508 11 09 10 13 15 16 20 21 2303 06 07 09 12 14 18 19 22 25 Quote Link to comment Share on other sites More sharing options...
Álvaro César Posted January 29, 2015 Share Posted January 29, 2015 116508 11 09 10 13 15 16 20 21 2303 06 07 09 12 14 18 19 22 25 Quote Link to comment Share on other sites More sharing options...
AIRTON MIRANDA Posted January 30, 2015 Share Posted January 30, 2015 1165. 01 05 09 12 14 19 20 21 23 24. 08 09 10 11 12 14 19 20 21 23. Quote Link to comment Share on other sites More sharing options...
CRodrigues Posted January 30, 2015 Share Posted January 30, 2015 Para o 1165: 01 02 05 06 07 09 13 15 20 2401 05 08 11 12 15 16 17 20 24 Quote Link to comment Share on other sites More sharing options...
Titus Posted January 30, 2015 Share Posted January 30, 2015 Ausentes 1165: 01-02-04-06-09-10-17-18-21-25 Quote Link to comment Share on other sites More sharing options...
Guest Zangado Posted January 31, 2015 Share Posted January 31, 2015 fiz uma função para numeres ausentes com um pouco de criatividade pode sr achar varios usos =NunAusente(Range; ocorrência ; Valor minimos ; valor maximo)=NunAusente(C10:Q10 ; 1 ; 1 ; 25)vai retornar a 1ª ocorrencia que falta de um numero de 1 até 25 em C10 até Q10 18 - 9 - 12 - 21 - 22 - 25 - 3 - 8 - 10 - 19 - 2 - 5 - 15 - 17 - 1 - ausentes: 1ª - 2ª - 3ª - 4ª - 5ª - 6ª - 7ª - 8ª - 9ª - 10ª - . 4 - 6 - 7 - 11 - 13 - 14 - 16 - 20 - 23 - 24 - Function NunAusente(ByVal Rang As Range, ByVal Ocorrencia As Long, ByVal Menor As Long, ByVal Maior As Long) As Long reg1 = Rang.Value2 Lc1 = UBound(reg1, 1): Cc1 = UBound(reg1, 2) ocr = 0 For v = Menor To Maior ttL = 0: GoSub tes If ttL = 0 Then ocr = ocr + 1 If ocr = Ocorrencia And ttL = 0 Then NunAusente = v: Exit Function Next Exit Functiontes: For L = 1 To Lc1 For c = 1 To Cc1 If reg1(L, c) = v Then ttL = 1: Exit For Next: NextReturnEnd Function Quote Link to comment Share on other sites More sharing options...
AIRTON MIRANDA Posted January 31, 2015 Share Posted January 31, 2015 Alô! amigos. Obrigado aos 03 participantes. Edcronos não entendi nada velho! 1- CRodrigues.................. 05 ausentes.1- Álvaro César................ 05 ausentes.2- Airton...................... 04 ausentes.3- Titus....................... 02 ausentes. Quote Link to comment Share on other sites More sharing options...
Álvaro César Posted February 1, 2015 Share Posted February 1, 2015 116606 07 08 12 13 14 18 19 20 22=========================02 03 05 08 09 15 17 18 19 22 Quote Link to comment Share on other sites More sharing options...
AIRTON MIRANDA Posted February 2, 2015 Share Posted February 2, 2015 1166. 01 05 08 10 14 15 17 20 21 23. 04 05 08 10 11 13 17 20 21 23. Quote Link to comment Share on other sites More sharing options...
Bigode Posted February 2, 2015 Share Posted February 2, 2015 10 Ausentes Conc. 1166 [ 07 09 11 12 14 16 18 20 23 25 ][ 02 04 07 09 13 15 16 17 19 24 ] Quote Link to comment Share on other sites More sharing options...
Titus Posted February 2, 2015 Share Posted February 2, 2015 Ausentes 1166: 03-04-05-08-09-10-12-14-20-23 Quote Link to comment Share on other sites More sharing options...
CRodrigues Posted February 2, 2015 Share Posted February 2, 2015 Ausentes 1166: 01 03 04 09 10 14 19 20 21 2203 07 10 13 14 16 19 20 21 22 Quote Link to comment Share on other sites More sharing options...
Bigode Posted February 3, 2015 Share Posted February 3, 2015 10 Ausentes Conc. 1166 [ 07 09 11 12 14 16 18 20 23 25 ][ 02 04 07 09 13 15 16 17 19 24 ] Quote Link to comment Share on other sites More sharing options...
AIRTON MIRANDA Posted February 3, 2015 Share Posted February 3, 2015 Alô! amigos. Obrigado aos 04 participantes. 1- CRodrigues............. 05 ausentes.1- Bigode................. 05 ausentes.2- Álvaro César........... 04 ausentes.2- Airton................. 04 ausentes.3- Titus.................. 03 ausentes. Quote Link to comment Share on other sites More sharing options...
Álvaro César Posted February 4, 2015 Share Posted February 4, 2015 116702 03 05 06 09 16 19 22 23 24========================01 08 11 12 13 14 17 18 20 21 Quote Link to comment Share on other sites More sharing options...
dr.ottovonlotto Posted February 4, 2015 Share Posted February 4, 2015 1167 01 02 05 06 08 11 13 16 20 2503 04 07 09 14 19 20 21 23 24 (players could bet for or against this roller.) Quote Link to comment Share on other sites More sharing options...
Bigode Posted February 4, 2015 Share Posted February 4, 2015 10 Ausentes Conc. 1167 [ 05 07 10 12 13 15 19 20 21 22 ][ 07 08 10 12 13 14 20 21 24 25 ] Quote Link to comment Share on other sites More sharing options...
AIRTON MIRANDA Posted February 4, 2015 Share Posted February 4, 2015 1167. 03 05 09 10 15 17 18 19 23 25. 01 03 09 10 14 15 17 20 21 23. Quote Link to comment Share on other sites More sharing options...
Titus Posted February 4, 2015 Share Posted February 4, 2015 1167 : 03- 04-07-12-13-14-15-18-21-24 Quote Link to comment Share on other sites More sharing options...
Bigode Posted February 5, 2015 Share Posted February 5, 2015 10 Ausentes Conc. 1167 [ 05 07 10 12 13 15 19 20 21 22 ][ 07 08 10 12 13 14 20 21 24 25 ] Quote Link to comment Share on other sites More sharing options...
dr.ottovonlotto Posted February 5, 2015 Share Posted February 5, 2015 1168 01 02 05 06 08 11 13 16 20 2503 04 07 09 14 19 20 21 23 24 (players could bet for or against this roller.) Quote Link to comment Share on other sites More sharing options...
AIRTON MIRANDA Posted February 5, 2015 Share Posted February 5, 2015 Alô! amigos. Obrigado aos 04 participantes. 1- Bigode.................. 05 ausentes.1- Airton.................. 05 ausentes.1- Álvaro César............ 05 ausentes.2- dr.ottovonlotto......... 04 ausentes.3- Titus................... 03 ausentes. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.