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 ...
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