Ask Experts Questions for FREE Help !
Ask
    martin16's Avatar
    martin16 Posts: 3, Reputation: 1
    New Member
     
    #1

    Jul 11, 2012, 05:31 AM
    Duplicate Values
    Hi,

    How to identify the duplicate values in same sheet. Eg. A1,A2,A3,A1.

    Regards,
    martin16's Avatar
    martin16 Posts: 3, Reputation: 1
    New Member
     
    #2

    Jul 11, 2012, 05:35 AM
    Hi,

    How to identify the duplicate values in same sheet. Eg. A1,A2,A3,A1.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Jul 11, 2012, 01:18 PM
    You can use CONDITIONAL FORMATTING to light up cells that are duplicates.

    For column A, for instance:

    1) Highlight column A
    2) Open the Conditional Formatting window and apply a new custom rule with this formula:

    =COUNTIF(A:A, A1)>1
    suzier's Avatar
    suzier Posts: 6, Reputation: 1
    New Member
     
    #4

    Jul 15, 2012, 12:40 PM
    The "advanced" filter option on the "Data" dropdown menu has the "unique records only". This feature will remove the duplicates from the list. Actually it "hides" the rows unless you opt to copy the data to a new location.
    martin16's Avatar
    martin16 Posts: 3, Reputation: 1
    New Member
     
    #5

    Jul 18, 2012, 05:31 AM
    Hi,

    Thank you for the solution.

    one more clarification if the values are duplicate in the same rows; then how to enable those duplicate valuse in next rows.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #6

    Jul 18, 2012, 08:27 AM
    Please elaborate... or attach a sample workbook demonstrating everything you're talking about. Mock it all up manually so we can see everything.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Duplicate name [ 5 Answers ]

At startup a notice tells me I have duplicate names on my PC.Only my name is in server accounts so how do I find the 2nd one to delete,cheers

Can't duplicate hyperlink [ 3 Answers ]

In the past, if I copied a browser address into a Works document, the address would underline in blue and was clickable to open that browser address from within the Works document. For some reason, that is no longer valid. I can't think of any changes I've made to Firefox to alter this action. How...

Duplicate IP [ 1 Answers ]

Daer all Good morning , I'm very pleasure to join your forum , I have problem with My router which is connected to RADIUS server , more than one can connect with Specific username , hence they will take same IP , I want any command in CISCO ...


View more questions Search