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

%3CLINGO-SUB%20id%3D%22lingo-sub-1353955%22%20slang%3D%22en-US%22%3EIn%20a%20SINGLE%20CELL%20is%20there%20a%20way%20to%20remove%20a%20duplicate%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1353955%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20select%20a%20single%20cell%20and%20have%20a%20filter%20identify%20a%20duplicated%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE.G.%20if%20I%20have%20the%20formula%20in%20a%20single%20cell%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D'BP-MLStown'!C6%2BUSRealty!C6%2BVisionLaw!C53%2BVisionLaw!C53%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20filter%20to%20identify%20in%20this%20single%20cell%20that%26nbsp%3BVisionLaw!C53%20was%20duplicated%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1353955%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1354059%22%20slang%3D%22en-US%22%3ERe%3A%20In%20a%20SINGLE%20CELL%20is%20there%20a%20way%20to%20remove%20a%20duplicate%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1354059%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F644805%22%20target%3D%22_blank%22%3E%40Opticast%3C%2FA%3E%26nbsp%3Bcheck%20this%20solution%2C%20you'll%20have%20to%20create%20a%20function%20in%20VBA%20and%20then%20use%20it%20to%20remove%20duplicate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F15805157%2Fhow-do-i-remove-duplicate-values-in-a-cell-seperated-with-a%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F15805157%2Fhow-do-i-remove-duplicate-values-in-a-cell-seperated-with-a%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

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