Good Morning,
I don't see easy, is a bit complicated my goal
I'm struggling with a formula to count the matched reference on a Range to be matched.
I know that are a some some formulas that do that job, but what i need to do is go a lil beyond the count.
I applied the formulas , Count, Countif, Sumproduct w countif, sumproduct w match, Sum if frequency w match,
Even, i nested 5 countif formulas.
The Count is correct as long if both range have no duplicated (reference VS Range)
BUT once it is a duplicated value on Range or References, the count is not what i need.
Note: if reference has duplicated, each duplicated need to be counted as 1, Even if in the Range is more 2 or more times.
Example
https://www.dropbox.com/s/qp93l86lc05wzx0/CountSample.png?dl=0
Thank you!!
I don't see easy, is a bit complicated my goal
I'm struggling with a formula to count the matched reference on a Range to be matched.
I know that are a some some formulas that do that job, but what i need to do is go a lil beyond the count.
I applied the formulas , Count, Countif, Sumproduct w countif, sumproduct w match, Sum if frequency w match,
Even, i nested 5 countif formulas.
The Count is correct as long if both range have no duplicated (reference VS Range)
BUT once it is a duplicated value on Range or References, the count is not what i need.
Note: if reference has duplicated, each duplicated need to be counted as 1, Even if in the Range is more 2 or more times.
Example
https://www.dropbox.com/s/qp93l86lc05wzx0/CountSample.png?dl=0
Thank you!!
Last edited by a moderator: