Sobe_e_Desce_2.0.xlsx | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | D | E | F | G | H | I | K | L | M | N | O | P | Q | R | S | T | U | |||||
2 | Usuário | Tempo | Cargos | Separador | Horas | Separador | Qual a Equipe? | Ids | Qual a Equipe? | Equipe | ID | ||||||||||||
3 | MGL229456993373519872 | 161 Horas 16 Minutos 49 Segundos | 869353363609899042, 869353363622494315, 869353363635073066, 869353363635073071, 869353363647651886, 869353363647651889, 869353363656020030, 869353363656020033, 869353363656020035, 869353363668598799, 869353363668598801, 869353363677020210, 869353363677020212, 869353363677020215, 869353363677020219, 869353363714744337, 869353363794444395, 869353363807010852, 869353363815411754, 869353363815411755, 869353363832180797, 869353363844780126, 869353363861536791, 869353764727947324, 879479435332579329, 892270088286273586, 896811812132110336, 917381741084295198, 923768995981697114, 934915112270188555, 941733727610998804, 963086806784565328, 970862133929730138, 987429669550850118, 989523321014079488, 992073031348400138, 869353363609899038 | ||| | 161 | 161 | ||| | Equipe Mov.Call | <@229456993373519872> | Equipe Mov.Call | 869353363815411757 | Equipe Eventos | 869353363815411757 | ||||||||||
4 | oyuric755287807337169017 | 141 Horas 33 Minutos 9 Segundos | 869353363609899042, 869353363635073066, 869353363635073072, 869353363668598798, 869353363668598799, 869353363668598801, 869353363677020210, 869353363677020212, 869353363677020215, 869353363807010852, 869353363807010855, 869353363815411753, 869353363823816720, 869353363861536791, 869353764727947324, 879479406039531562, 892270088286273586, 896811812132110336, 934915112270188555, 970862133929730138, 978155147928674324, 869353363609899038 | ||| | 141 | 141 | ||| | Equipe Registro | <@755287807337169017> | Equipe Registro | 869353363815411758 | Auxiliar Eventos | 869353363815411758 | ||||||||||
5 | lais bianchessi960299650810794004 | 133 Horas 28 Minutos 38 Segundos | 869353363609899042, 869353363635073066, 869353363635073072, 869353363647651883, 869353363647651889, 869353363656020029, 869353363656020030, 869353363656020032, 869353363668598798, 869353363668598799, 869353363668598801, 869353363668598804, 869353363677020212, 869353363677020215, 869353363807010852, 869353363815411754, 869353764727947324, 892270088286273586, 901201959556616212, 941733727610998804, 988969269536649246, 869353363609899038 | ||| | 133 | 133 | ||| | Equipe Mov.Call | <@960299650810794004> | Equipe Mov.Call | 869353363815411754 | Equipe Mov.Call | 869353363815411754 | ||||||||||
6 | ! Ryo𝐾en961772149956309079 | 127 Horas 41 Minutos 13 Segundos | 869353363609899040, 869353363609899042, 869353363609899044, 869353363635073066, 869353363635073068, 869353363635073069, 869353363647651889, 869353363656020029, 869353363656020031, 869353363656020034, 869353363668598798, 869353363668598799, 869353363668598802, 869353363677020210, 869353363677020212, 869353363677020214, 869353363677020215, 869353363731533894, 869353363807010852, 869353363815411754, 869353363815411757, 869353363874131972, 869353363886710784, 869353764727947324, 879479435332579329, 892270088286273586, 933510183257272321, 934915112270188555, 940077814516953088, 963086806784565328, 973715342046146590, 973715650528833598, 988969269536649246, 869353363609899038 | ||| | 127 | 127 | ||| | Equipe Eventos | <@961772149956309079> | Equipe Eventos | 869353363815411756 | Equipe Recrutamento | 869353363815411756 | ||||||||||
7 | Alves .мv858781483149819945 | 124 Horas 40 Minutos 17 Segundos | 869353363609899040, 869353363635073068, 869353363647651880, 869353363656020033, 869353363668598799, 869353363677020210, 869353363677020212, 869353363677020214, 869353363677020215, 869353363794444395, 869353363807010852, 869353363815411758, 869353363832180800, 869353363886710784, 879479435332579329, 892270088286273586, 901201918481821697, 923768995981697114, 934915112270188555, 941733727610998804, 950958148557090836, 955288897632485427, 963086806784565328, 970862133929730138, 978155147928674324, 978779998502670416, 981030539815452672, 983118451012927518, 869353363609899038 | ||| | 124 | 124 | ||| | Auxiliar Eventos | <@858781483149819945> | Auxiliar Eventos | 869353363815411755 | Equipe Divulgação | 869353363815411755 | ||||||||||
8 | Gaguinho.lz931988559970332704 | 122 Horas 10 Minutos 24 Segundos | 869353363609899040, 869353363609899042, 869353363635073066, 869353363635073071, 869353363668598798, 869353363668598799, 869353363668598801, 869353363668598804, 869353363677020212, 869353363677020215, 869353363807010852, 869353363807010855, 869353363815411754, 869353764727947324, 879479406039531562, 892270088286273586, 896811812132110336, 901201955903406171, 934915112270188555, 973019878900531271, 992073031348400138, 869353363609899038 | ||| | 122 | 122 | ||| | Equipe Mov.Call | <@931988559970332704> | Equipe Mov.Call | 869353363815411752 | Equipe CDC | 869353363815411752 | ||||||||||
9 | calango966333127716909118 | 122 Horas 6 Minutos 11 Segundos | 869353363609899042, 869353363635073066, 869353363656020031, 869353363668598798, 869353363668598799, 869353363677020210, 869353363677020212, 869353363677020215, 869353363807010852, 869353363815411753, 869353363815411756, 869353363874131971, 869353764727947324, 892270088286273586, 934915112270188555, 963086806784565328, 973715650528833598, 978155147928674324, 991499849826578502, 869353363609899038 | ||| | 122 | 122 | ||| | Equipe Recrutamento | <@966333127716909118> | Equipe Recrutamento | 869353363815411753 | Equipe Registro | 869353363815411753 | ||||||||||
10 | ! HUNTER370612816291561474 | 121 Horas 7 Minutos 14 Segundos | 869353363647651886, 869353363656020032, 869353363656020033, 869353363668598797, 869353363668598798, 869353363668598802, 869353363668598804, 869353363677020212, 869353363677020214, 869353363677020215, 869353363714744338, 869353363807010852, 869353363815411754, 869353363823816722, 869353363844780126, 879479412733665312, 892270088286273586, 923768995981697114, 933510165607632906, 963086806784565328, 970862133929730138, 988969269536649246, 989523321014079488, 992073031348400138, 869353363609899038 | ||| | 121 | 121 | ||| | Equipe Mov.Call | <@370612816291561474> | Equipe Mov.Call | 973715650528833598 | Equipe Suporte | 973715650528833598 | ||||||||||
11 | ! 𝘽𝙚𝙯𝙚𝙧𝙧𝙤👑906573722838761562 | 120 Horas 4 Minutos 11 Segundos | 869353363609899042, 869353363635073066, 869353363656020031, 869353363656020035, 869353363656020037, 869353363668598797, 869353363668598798, 869353363668598799, 869353363668598802, 869353363677020210, 869353363677020212, 869353363677020214, 869353363677020215, 869353363794444395, 869353363807010852, 869353363815411754, 869353363815411759, 869353363823816720, 869353764727947324, 879479406039531562, 892270088286273586, 933510165607632906, 934915112270188555, 940077814516953088, 941733727610998804, 955288897632485427, 963086806784565328, 973715650528833598, 989523321014079488, 869353363609899038 | ||| | 120 | 120 | ||| | Equipe Mov.Call | <@906573722838761562> | Equipe Mov.Call | 869353363807010855 | Equipe Design | 869353363807010855 | ||||||||||
12 | ! Sr.Natsuzinho667095822101512194 | 118 Horas 41 Minutos 54 Segundos | 869353363609899042, 869353363635073066, 869353363668598801, 869353363668598804, 869353363677020212, 869353363677020214, 869353363677020215, 869353363807010852, 869353363807010855, 869353363815411754, 869353363844780126, 869353764727947324, 886458500862054470, 892138408418377730, 892270088286273586, 896811812132110336, 901201926312566845, 934915112270188555, 941733727610998804, 945458390333784146, 945790336070983750, 955288897632485427, 962805646099640340, 963086806784565328, 970207907369078784, 970862133929730138, 977985735317655552, 978155147928674324, 989523321014079488, 992073031348400138, 869353363609899038 | ||| | 118 | 118 | ||| | Equipe Mov.Call | <@667095822101512194> | Equipe Mov.Call | 869353363807010854 | Equipe Hot | 869353363807010854 | ||||||||||
13 | Guh ツ692180947990216725 | 112 Horas 7 Minutos 58 Segundos | 869353363609899042, 869353363635073066, 869353363635073070, 869353363647651889, 869353363668598799, 869353363668598801, 869353363677020210, 869353363677020212, 869353363677020215, 869353363807010852, 869353363815411754, 869353764727947324, 892270088286273586, 896811812132110336, 901201926312566845, 934915112270188555, 935385249389608991, 978779998502670416, 989523321014079488, 992073031348400138, 869353363609899038 | ||| | 112 | 112 | ||| | Equipe Mov.Call | <@692180947990216725> | Equipe Mov.Call | 896811812132110336 | Equipe EXAFLIX | 896811812132110336 | ||||||||||
14 | ! Tsuna 希787068655070347287 | 94 Horas 21 Minutos 39 Segundos | 869353363609899040, 869353363609899042, 869353363622494314, 869353363622494315, 869353363635073066, 869353363647651883, 869353363647651886, 869353363647651889, 869353363656020029, 869353363668598798, 869353363668598799, 869353363668598802, 869353363677020210, 869353363677020212, 869353363677020217, 869353363731533902, 869353363794444395, 869353363807010852, 869353363832180800, 869353363886710784, 869353363886710791, 869353363895107672, 879479435332579329, 892270088286273586, 906937079194325092, 941733727610998804, 991499849826578502, 992073031348400138, 869353363609899038 | ||| | 94 | 94 | ||| | <@787068655070347287> | 962805646099640340 | Equipe Jornalismo | 962805646099640340 | ||||||||||||
15 | ! bru 🍥795107916989857812 | 81 Horas 11 Minutos 54 Segundos | 869353363668598801, 869353363677020210, 869353363677020212, 869353363677020217, 869353363807010852, 869353363815411753, 869353363832180797, 869353764727947324, 892270088286273586, 978155147928674324, 869353363609899038 | ||| | 81 | 81 | ||| | Equipe Registro | <@795107916989857812> | Equipe Registro | 993257880927076392 | Equipe Games | 993257880927076392 | ||||||||||
Planilha1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F3:F15 | F3 | =LEFT(B3,3) |
G3:G15 | G3 | =--SUBSTITUTE(F3,"H","") |
I3:I15 | I3 | =IFERROR(@INDEX(T$3:T$15,AGGREGATE(15,6,(ROW(T$3:T$15)-ROW(U$3)+1)/ISNUMBER(SEARCH(U$3:U$15,D3)),1)),"") |
K3:K15 | K3 | =CONCAT("<@",J3,">") |
L3:L15 | L3 | =IFERROR(@INDEX(T$3:T$15,AGGREGATE(15,6,(ROW(T$3:T$15)-ROW(T$3)+1)/ISNUMBER(SEARCH(U$3:U$15,D3)),1)),"") |
U3:U15 | U3 | =RIGHT(S3,18) |
Tryind to use INDEX - MATCH and IFERROR to find in a location X results. The results im trying to find is " ID " that will result in " Equipe " and it will match from "Cargos" , but i dont know how to make it show multiple matchs, so how can i do it? tryed googling but i dont know the right terms for in english and in my language (pt-br) it doesnt has that much info
Last edited: