Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Duplicate Values (https://www.askmehelpdesk.com/showthread.php?t=681417)

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

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

    Regards,
  • Jul 11, 2012, 05:35 AM
    martin16
    Hi,

    How to identify the duplicate values in same sheet. Eg. A1,A2,A3,A1.
  • Jul 11, 2012, 01:18 PM
    JBeaucaire
    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
  • Jul 15, 2012, 12:40 PM
    suzier
    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.
  • Jul 18, 2012, 05:31 AM
    martin16
    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.
  • Jul 18, 2012, 08:27 AM
    JBeaucaire
    Please elaborate... or attach a sample workbook demonstrating everything you're talking about. Mock it all up manually so we can see everything.

  • All times are GMT -7. The time now is 06:03 AM.