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:=countif(C$2:C$310,C2)>1
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