FUNCION UNIQUE

%3CLINGO-SUB%20id%3D%22lingo-sub-1590210%22%20slang%3D%22es-ES%22%3EUNIQUE%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590210%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20uh%20I've%20been%20using%20the%20formula%20'UNICOS(FILTER(%3C%2FP%3E%3CP%3Eif%20no%20problem%2C%20but%20I%20want%20to%20use%20it%20inside%20a%20pivot%20table%20and%20I%20get%20%22OVERFLOW%22%2C%20does%20anyone%20know%20why%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1590210%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1590305%22%20slang%3D%22en-US%22%3ERE%3A%20FUNCION%20UNIQUE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590305%22%20slang%3D%22en-US%22%3Ecopy%2Fpaste%20the%20pivot%20table%20as%20%22values%22%20then%20apply%20the%20formula%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hola, eh estado utilizando la formula =UNICOS(FILTRAR(

si ningún problema, pero quiero utilizarla dentro de una tabla dinámica y me aparece"DESBORDAMIENTO", ¿alguien sabe el porque?

1 Reply
Highlighted
copy/paste the pivot table as "values" then apply the formula