I am impressed! How do you know the SINGLE trick? Thanks for sharing! PS: SINGLE works on a French implementation. PPS: the PIVOTEVERYNROWS function doesn not need the "n" argument which could be calculated by COUNTA(UNIQUE(attribute)) (unless I am missing an other usage of the function) Thanks again
@@flexyourdata Sorry, I have 365, I am in Spain and I don't see SINGLE. I don't know what function.I don't know how that function could be translated. I can not find it. With LAMBDA it doesn't work for me either.
It's amazing! Thanks for sharing.
Thanks! I appreciate your feedback.
I am impressed! How do you know the SINGLE trick? Thanks for sharing!
PS: SINGLE works on a French implementation.
PPS: the PIVOTEVERYNROWS function doesn not need the "n" argument which could be calculated by COUNTA(UNIQUE(attribute))
(unless I am missing an other usage of the function)
Thanks again
SINGLE function doesn't exist en 365 version. Is it possible to work with the @ symbol? How? Thank you.
I'm using 365. SINGLE function is definitely there. Just not listed.
If you don't want to or can't use SINGLE, you can use this:
LAMBDA(x, @x)
@@flexyourdata Sorry, I have 365, I am in Spain and I don't see SINGLE. I don't know what function.I don't know how that function could be translated. I can not find it. With LAMBDA it doesn't work for me either.
@@IvanCortinas_ES Please try the Spanish name for the function. I believe it is UNICO.
I don't know what happened, but pivotby is not taking text as a value anymore, at all. Error values only.