May 01 2020 02:41 PM
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?
May 01 2020 03:55 PM
@Opticast check this solution, you'll have to create a function in VBA and then use it to remove duplicate.