Forum Discussion
How to identify this duplicate Value
Here the attached excel both the values are the same. How to identify this duplicate value.
6 Replies
They are not exactly the same: in C4, there are two spaces between HOLISTIC and INTERNATIONAL. In C5, there is only one space between those words.
You might replace all occurrences of two spaces with one space, you can then use Remove Duplicates on the Data tab of the ribbon.
- Could you please guide how to remove the two spaces between the two words.
=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.
