Hello
How can we highlight duplicates in google sheet as I could not find the highlight => Duplicates in conditional formating.
Best Regards
Imran bhatti
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
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
Thanks McStagger but sadly the mentioned formula is not working
I want to highlight the duplicate entry in C column on a google sheet.=countif(C2:C310,C1)>1
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.
Try:Let us know if you have any questions.Formula:Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks