Forum Discussion
In a SINGLE CELL is there a way to remove a duplicate value?
Is there a way to select a single cell and have a filter identify a duplicated value.
E.G. if I have the formula in a single cell:
='BP-MLStown'!C6+USRealty!C6+VisionLaw!C53+VisionLaw!C53
Is there a filter to identify in this single cell that VisionLaw!C53 was duplicated?
1 Reply
Opticast check this solution, you'll have to create a function in VBA and then use it to remove duplicate.
https://stackoverflow.com/questions/15805157/how-do-i-remove-duplicate-values-in-a-cell-seperated-with-a
