3,939 questions
I translate your problem, in my opinion, you're looking for advanced filter:
Select column A- go to Data- Advanced- select Criteria range:
Filtrar datos en excel con una lista de elementos en otra hoja.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 22%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Brandon Josue Suchite Rodriguez
1
Reputation point
Quiero filtrar una lista de datos usando una lista de elementos que esta en otra hoja. Ejemplo
En hoja 1: Columna A. tengo una lista de códigos de 5 dígitos. En 1,000 filas.
En hoja 2. Columna A: tengo otra lista de códigos de 5 dígitos. En una lista de 50 filas
Lo que necesito es saber como filtrar La Columna A. de la hoja 1. usando la lista de 50 filas que se encuentran en la hoja 2.
Lo que no quiero es estar buscando o filtrando uno por uno.
Microsoft 365 and Office | Excel | For business | Windows
{count} votes
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff2020-08-14T08:15:26.457+00:00 This is an English forum, please edit the thread and translate it to English language.
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
2020-08-28T09:18:32.293+00:00 I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
2020-09-01T09:00:21.753+00:00 Hi @Brandon Josue Suchite Rodriguez ,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Sign in to comment
1 answer
Sort by: Most helpful
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
2020-08-14T08:53:37.303+00:00