Ok, I imagined that. I knew about the "False-autofill", but thought it would be necessary to use that trick with "--" before the parenthesis to convert the "false" strings in zeros.
Thanks again.
Thanks Luke and Hui. It just worked as well as I wanted.
I was looking for this formula about a month... LOL aways to avoid Pivot Tables and not reeeeaaally needing to find it, just to study and keep it safe for the right opportunity. And now it came. Thanks again.
Just a doubt? Why don't we...
Hi everyone,
Here's my deal: I have a bench of data with some columns and I want to count the unique values (if any value appears more than once, just count it once) respecting a criteria.
Let's imagine this data:
_______________________________________________________
A B C...