Forum Discussion
How to identify this duplicate Value
Here the attached excel both the values are the same. How to identify this duplicate value.
=SUBSTITUTE(C4," ","")=SUBSTITUTE(C5," ","")Maybe with this formula. "WAHR" is "TRUE" in english.
Thanks for the Support
My issue is that from the group of data how do find the duplicate value?
please find the attached copy.
=IF(COUNTIF($C$17:$C$27,C17)>1,"duplicate","")This is the formula in cell D17.
=SUBSTITUTE(C4," ","")This is the formula in cell C17. Both formulas are filled down.
The equation is not detected in this customer
