Tenho uma dúvida de como posso filtrar registros repetitivos (No meu caso endereços IP) . Para essa tarefa utiliza a planilha eletrônica. No exel eu utilizo o filtro avançado com sucesso.
1. Dados 2. Filtrar 3. Filtros avançados. 4. Preencho os intervalos de listas / intervalos de critério. 5. Marcos a caixa "somente registro exclusivo" Sucesso ! No calc no Broffice o procedimento não é muito diferente. 1. Dados 2. Filtrar 3. Filtros Avançados 4. Preencho Preencho os critérios de filtragem. 5. Marco a caixa "Sem duplicação." Recebo a seguinte mensagem "Este intervalo não contém uma consulta válida" Alguém na lista sabe como posso fazer para filtrar esses dados ? Exemplo de registro duplicados: 64.97.155.9 64.97.155.9 64.97.155.9 64.97.155.9 64.97.155.9 64.97.155.8 64.97.155.8 64.97.155.8 64.97.155.8 64.97.155.8 64.97.155.7 64.97.155.7 64.97.155.7 64.97.155.7 64.97.155.7 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.63 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.61 64.97.155.60 64.97.155.60 64.97.155.60 64.97.155.60 64.97.155.60 64.97.155.60 64.97.155.60 64.97.155.60 64.97.155.60 64.97.155.60 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.59 64.97.155.58 64.97.155.58 64.97.155.58 64.97.155.58 64.97.155.58 64.97.155.57 64.97.155.57 64.97.155.57 64.97.155.57 64.97.155.57 64.97.155.57 64.97.155.57 64.97.155.57 64.97.155.57 64.97.155.57 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.56 64.97.155.54 64.97.155.54 64.97.155.54 64.97.155.54 64.97.155.54 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.53 64.97.155.52 64.97.155.52 64.97.155.52 64.97.155.52 64.97.155.52 64.97.155.52 64.97.155.52 64.97.155.52 64.97.155.52 64.97.155.52 64.97.155.51 64.97.155.51 64.97.155.51 64.97.155.51 64.97.155.51 64.97.155.51 64.97.155.51 64.97.155.51 64.97.155.51 64.97.155.51 64.97.155.50 64.97.155.50 64.97.155.50 64.97.155.50 64.97.155.50 64.97.155.5 64.97.155.5 64.97.155.5 64.97.155.5 64.97.155.5 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.46 64.97.155.45 64.97.155.45 64.97.155.45 64.97.155.45 64.97.155.45 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.44 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.43 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.42 64.97.155.41 64.97.155.41 64.97.155.41 64.97.155.41 64.97.155.41 64.97.155.40 64.97.155.40 64.97.155.40 64.97.155.40 64.97.155.40 64.97.155.4 64.97.155.4 64.97.155.4 64.97.155.4 64.97.155.4 64.97.155.39 64.97.155.39 64.97.155.39 64.97.155.39 64.97.155.39 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.37 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.36 64.97.155.35 64.97.155.35 64.97.155.35 64.97.155.35 64.97.155.35 64.97.155.34 64.97.155.34 64.97.155.34 64.97.155.34 64.97.155.34 64.97.155.33 64.97.155.33 64.97.155.33 64.97.155.33 64.97.155.33 64.97.155.32 64.97.155.32 64.97.155.32 64.97.155.32 64.97.155.32 64.97.155.31 64.97.155.31 64.97.155.31 64.97.155.31 64.97.155.31 64.97.155.31 64.97.155.31 64.97.155.31 64.97.155.31 64.97.155.31 64.97.155.3 64.97.155.3 64.97.155.3 64.97.155.3 64.97.155.3 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.29 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.27 64.97.155.26 64.97.155.26 64.97.155.26 64.97.155.26 64.97.155.26 64.97.155.26 64.97.155.26 64.97.155.26 64.97.155.26 64.97.155.26 64.97.155.25 64.97.155.25 64.97.155.25 64.97.155.25 64.97.155.25 64.97.155.25 64.97.155.25 64.97.155.25 64.97.155.25 64.97.155.25 64.97.155.24 64.97.155.24 64.97.155.24 64.97.155.24 64.97.155.24 64.97.155.24 64.97.155.24 64.97.155.24 64.97.155.24 64.97.155.24 64.97.155.21 64.97.155.21 64.97.155.21 64.97.155.21 64.97.155.21 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.20 64.97.155.2 64.97.155.2 64.97.155.2 64.97.155.2 64.97.155.2 64.97.155.2 64.97.155.2 64.97.155.2 64.97.155.2 64.97.155.2 64.97.155.19 64.97.155.19 64.97.155.19 64.97.155.19 64.97.155.19 64.97.155.19 64.97.155.19 64.97.155.19 64.97.155.19 64.97.155.19 64.97.155.18 64.97.155.18 64.97.155.18 64.97.155.18 64.97.155.18 64.97.155.18 64.97.155.18 64.97.155.18 64.97.155.18 64.97.155.18 64.97.155.17 64.97.155.17 64.97.155.17 64.97.155.17 64.97.155.17 64.97.155.17 64.97.155.17 64.97.155.17 64.97.155.17 64.97.155.17 64.97.155.16 64.97.155.16 64.97.155.16 64.97.155.16 64.97.155.16 64.97.155.15 64.97.155.15 64.97.155.15 64.97.155.15 64.97.155.15 64.97.155.15 64.97.155.15 64.97.155.15 64.97.155.15 64.97.155.15 64.97.155.14 64.97.155.14 64.97.155.14 64.97.155.14 64.97.155.14 64.97.155.14 64.97.155.14 64.97.155.14 64.97.155.14 64.97.155.14 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.12 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1 64.97.155.1
