Agrupar por intervalos diferentes

%3CLINGO-SUB%20id%3D%22lingo-sub-1659903%22%20slang%3D%22es-ES%22%3EGroup%20by%20different%20intervals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1659903%22%20slang%3D%22es-ES%22%3E%3CP%3EBest%20regards.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20database%20with%20a%20list%20of%20companies%20and%20debts.%20I%20was%20asked%20to%20count%2C%20using%20different%20intervals%2C%20how%20many%20companies%20fall%20into%20it.%20For%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELess%20than%200%3A3%3C%2FP%3E%3CP%3E0%20to%201%2C500%3A%208%3C%2FP%3E%3CP%3E1501%20to%202000%3A%205%3C%2FP%3E%3CP%3EMore%20than%202000%3A%204%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20am%20asked%20to%20deploy%20the%20companies%20in%20question%20(e.g.%20the%20name%20of%20the%204%20companies%20with%20more%20than%202000).%20I%20saw%20that%20with%20PivotTables%20it%20allows%20you%20to%20group%20values%2C%20but%20only%20with%20equal%20intervals%20(e.g.%20intervals%200%20to%20500%2C%20500%20to%201000%2C%20etc...)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20group%20them%20together%20but%20using%20different%20size%20intervals%20(as%20in%20the%20example)%3F%3C%2FP%3E%3CP%3EIf%20it%20is%20not%20possible%2C%20what%20would%20be%20a%20way%20to%20perform%20this%20task%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20attention.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1659903%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660095%22%20slang%3D%22en-US%22%3ERe%3A%20Agrupar%20por%20intervalos%20diferentes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F790986%22%20target%3D%22_blank%22%3E%40jljassos%3C%2FA%3E%26nbsp%3BYou%20can%20use%20the%20table%20shown%20in%20CONTEO.jpg%20to%20lookup%20the%20label%20name%20and%20add%20it%20to%20each%20record%20in%20your%20database.%20Then%2C%20create%20a%20pivot%20table%20with%20interval%20and%20name%20as%20rows%2C%20as%20shown%20in%20the%20attached%20example.%20Hide%20the%20value%20column%20if%20you%20only%20want%20to%20show%20a%20list%20of%20names%20within%20each%20interval.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Saludos.

 

Tengo una base de datos con una lista de empresas y deudas. Me pidieron que cuente, usando distintos intervalos, cuántas empresas caen en ella. Por ejemplo:

 

Menos de 0: 3

de 0 a 1,500: 8

de 1501 a 2000: 5

Más de 2000: 4

 

Sin embargo, me piden que se desplieguen las empresas en cuestión (ej. el nombre de las 4 empresas con más de 2000). Ví que con tablas dinámicas te permite agrupar los valores, pero solo con intervalos iguales (ej. los intervalos 0 a 500, 500 a 1000, etc...)

 

¿Hay alguna manera de agruparlos pero usando intervalos de diferente tamaño (como en el ejemplo)?

En caso de que no se pueda, ¿cuál sería una forma de realizar esta tarea?

 

Gracias por su atención.

1 Reply
Highlighted

@jljassos You can use the table shown in CONTEO.jpg to lookup the label name and add it to each record in your database. Then, create a pivot table with interval and name as rows, as shown in the attached example. Hide the value column if you only want to show a list of names within each interval.