In a SINGLE CELL is there a way to remove a duplicate value?

Copper Contributor

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