Results 1 to 3 of 3

Finding duplicates inside text strings

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2010
    Location
    Huddersfield, England
    MS-Off Ver
    Excel 2010
    Posts
    58

    Finding duplicates inside text strings

    I know how to find duplicate cells by using conditional formatting

    =COUNTIF(A:A,A5>1
    Is there a way to only search characters 3 to 6 in a string to find duplicates, not the whole text?
    Last edited by snoopy1461; 04-01-2011 at 11:08 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1