I know how to find duplicate cells by using conditional formatting
Is there a way to only search characters 3 to 6 in a string to find duplicates, not the whole text?![]()
=COUNTIF(A:A,A5>1
I know how to find duplicate cells by using conditional formatting
Is there a way to only search characters 3 to 6 in a string to find duplicates, not the whole text?![]()
=COUNTIF(A:A,A5>1
Last edited by snoopy1461; 04-01-2011 at 11:08 AM. Reason: Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks