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:
Is there a filter to identify in this single cell that VisionLaw!C53 was duplicated?
@Opticast check this solution, you'll have to create a function in VBA and then use it to remove duplicate.