+ Reply to Thread
Results 1 to 2 of 2

Find Cell which some texts are Duplicate

  1. #1
    Registered User
    Join Date
    11-19-2012
    Location
    Pune
    MS-Off Ver
    Excel 2010
    Posts
    23

    Find Cell which some texts are Duplicate

    Dear All

    plz help me,

    I have to find, a B1 cell in which some texts are present in the A1

    Eg.

    A1........................ B1
    Power..............Power Pattabhi
    Power..............Pattabhi


    Thanks in Advane
    Last edited by Bharatdubole; 11-20-2012 at 05:52 AM.

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Find Cell which some texts are Duplicate

    Hi

    Use your conditional formatting select new rule and then format only unique or duplicate values, select duplicate that should do it for you.

    Chris
    Click my star if I helped Thanks

+ Reply to Thread

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