<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Pessoal,<div><br></div><div>Gostaria de comparar informações de determinada tabela considerando suas linhas, mas não sei como fazer. Utilizando a notação abaixo para exemplificar, quero verificar se existe alguma linha da coluna A que apresenta valor repetido. Algo como, se a1 == an então retorna 1 em c1, caso contrário 0, do mesmo modo, se a2 == an retorna 1 em c2, caso contrário 0... Outra possibilidade útil é contar a quantidade de repetições de um "a" qualquer e retornar a soma da quantidade de repetições em c. Mas o que realmente seria útil era verificar se existe alguma linha onde a1==an e b1==bn, quando isso ocorrer retornar 1 em d1, caso contrário 0, do mesmo modo, se a2==an e b2==bn, retornar 1 em d2, caso contrário 0.</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; color: rgb(126, 71, 38); "><font class="Apple-style-span" face="Helvetica" size="3"><span class="Apple-tab-span" style="white-space:pre"> </span>A<span class="Apple-tab-span" style="white-space:pre"> </span>B<span class="Apple-tab-span" style="white-space:pre"> </span>C<span class="Apple-tab-span" style="white-space:pre"> </span>D</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; color: rgb(126, 71, 38); "><font class="Apple-style-span" face="Helvetica" size="3"><span style="color: #4800de">1<span class="Apple-tab-span" style="white-space:pre"> </span>a1</span><span class="Apple-tab-span" style="white-space:pre"> </span><span style="color: #4800de">b1</span><span class="Apple-tab-span" style="white-space:pre"> </span><span style="color: #4800de">c1</span><span class="Apple-tab-span" style="white-space:pre"> </span><span style="color: #4800de">d1<span class="Apple-tab-span" style="white-space:pre"> </span></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; color: rgb(72, 0, 222); "><font class="Apple-style-span" face="Helvetica" size="3">2<span class="Apple-tab-span" style="white-space:pre"> </span>a2<span style="color: #7e4726"><span class="Apple-tab-span" style="white-space:pre"> </span></span>b2<span style="color: #7e4726"><span class="Apple-tab-span" style="white-space:pre"> </span></span>c2<span style="color: #7e4726"><span class="Apple-tab-span" style="white-space:pre"> </span></span>d2<span class="Apple-tab-span" style="white-space:pre"> </span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; color: rgb(126, 71, 38); "><font class="Apple-style-span" face="Helvetica" size="3"><span style="color: #4800de">3<span class="Apple-tab-span" style="white-space:pre"> </span>a3</span><span class="Apple-tab-span" style="white-space:pre"> </span><span style="color: #4800de">b3</span><span class="Apple-tab-span" style="white-space:pre"> </span><span style="color: #4800de">c3</span><span class="Apple-tab-span" style="white-space:pre"> </span><span style="color: #4800de">d3<span class="Apple-tab-span" style="white-space:pre"> </span></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; color: rgb(126, 71, 38); "><font class="Apple-style-span" face="Helvetica" size="3"><span style="color: #4800de">4<span class="Apple-tab-span" style="white-space:pre"> </span>a4</span><span class="Apple-tab-span" style="white-space:pre"> </span><span style="color: #4800de">b4</span><span class="Apple-tab-span" style="white-space:pre"> </span><span style="color: #4800de">c4</span><span class="Apple-tab-span" style="white-space:pre"> </span><span style="color: #4800de">d4<span class="Apple-tab-span" style="white-space:pre"> </span></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; color: rgb(72, 0, 222); "><span class="Apple-style-span" style="font-family: Helvetica; font-size: medium; ">n<span class="Apple-tab-span" style="white-space:pre"> </span>an<span style="color: #7e4726"><span class="Apple-tab-span" style="white-space:pre"> </span></span>bn<span style="color: #7e4726"><span class="Apple-tab-span" style="white-space:pre"> </span></span>cn<span style="color: #7e4726"><span class="Apple-tab-span" style="white-space:pre"> </span></span>dn</span></div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; color: rgb(72, 0, 222); "><font class="Apple-style-span" face="Helvetica" size="3">onde n vai de 1 a +infinito</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; color: rgb(72, 0, 222); "><font class="Apple-style-span" face="Helvetica" size="3"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><font class="Apple-style-span" face="Helvetica" size="3">Atenciosamente</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><font class="Apple-style-span" face="Helvetica" size="3">Roney</font></div></body></html>