+ Reply to Thread
Results 1 to 5 of 5

How to highlight duplicates in google sheets?

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    How to highlight duplicates in google sheets?

    Hello

    How can we highlight duplicates in google sheet as I could not find the highlight => Duplicates in conditional formating.

    Best Regards
    Imran bhatti
    Teach me Excel VBA

  2. #2
    Registered User
    Join Date
    06-04-2014
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    72

    Re: How to highlight duplicates in google sheets?

    I dont know much about how Google Sheets works but I did find this which seems to have some successful instructions: http://stackoverflow.com/questions/2...le-spreadsheet

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: How to highlight duplicates in google sheets?

    Thanks McStagger but sadly the mentioned formula is not working
    =countif(C2:C310,C1)>1
    I want to highlight the duplicate entry in C column on a google sheet.

  4. #4
    Registered User
    Join Date
    06-04-2014
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    72

    Re: How to highlight duplicates in google sheets?

    If you scroll down the page, there is a response from CommonRaven that has 14 votes. That solution worked for my test. I hesitate to copy paste the solution as I do not know the rules for such a move on this forums and I do not want to run afoul of the forum or the moderators. It is the 3rd high level response to the problem, however.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: How to highlight duplicates in google sheets?

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to highlight/unhighlight duplicates accross many sheets
    By Lsxtrkiller in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-12-2016, 11:50 AM
  2. Compare 2 sheets, highlight duplicates on sheet 2
    By rubybegonia in forum Excel General
    Replies: 1
    Last Post: 02-17-2014, 05:33 PM
  3. Macro To Compare Multiple Excel sheets and highlight duplicates
    By Rey123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2013, 05:07 AM
  4. Compare, Find and Highlight Duplicates in multiple sheets
    By EvilleT in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2013, 08:42 PM
  5. Highlight duplicates across multiple sheets
    By Monkihunta in forum Excel General
    Replies: 0
    Last Post: 09-09-2013, 10:53 AM
  6. Highlight duplicates across two sheets or tables
    By Usta in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-18-2012, 07:52 PM
  7. Replies: 1
    Last Post: 09-28-2011, 07:42 PM

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