In this video, I show you how to highlight duplicate values in Google Sheets using conditional formatting. #spreadsheetlife #googlesheets #googlesheetstips #googlesheetstutorial
appreciate the video, it helps with my issue. but pls also upload this shot duration video into a normal youtube video, it's hard to watch in youtube shorts (bcs we can't go to the minute/time stamp we want freely. thank you so much ^^
I've been searching the right formula, but this shit countif appear in all videos I found. This isn't what I want. Inputs in my sheets contain dynamic dates and months. Data changes all the time. I adont want to always "MANUALLY" change or revised data. Besides all rows will always have different dates and months as time moves forward.
I'm sorry this video didn't provide the solution you were looking for. If you're up for it, email me at info@spreadsheetlife.com, and include a few screenshots and an explanation for your problem. I bet I can come up with a solution for you.
Gotcha! Gotcha. Check out this example where I apply the same formula I demonstrate in the video to just a single column with data that contains numbers and letters. It works! 😊👍 docs.google.com/spreadsheets/d/1YciJQhY7AndHzvGyOub5tbsRVKazsis-ECmsdO4-GL8/copy Just make sure you've got your references right.