Hello All, I hope you are enjoying your days !!!. Friends Google Sheets is a better alternative to Microsoft Office. If you cannot afford Microsoft Office then I recommend using Google Sheets. You know Google Sheets is free, yes it is totally free.
Friends as per the post headline you already understand what I want to share. Believe me, today’s post is very interesting & we will learn how we can check duplicate values in Google Sheets. So without any delay let’s start & come to the topic.
Duplicate Values in Google Sheets:
Hmmm, today we are going to learn one of the best interesting information about Google Sheets. Are you ready for this ??
We will learn it through and in a few simple steps –
Step 1 :
- Open Google Sheets. For new google sheets, just take login into Google and type in the browser: https://docs.google.com/spreadsheets
- Now open your Google Sheets document and navigate to the sheet where you want to check for duplicates.
- After that just select the column or range of cells where you suspect duplicate values may exist. You can do this by clicking and dragging your mouse over the cells.
- In the menu bar, click on “Format” and then select “Conditional formatting” from the drop-down menu.
- In the Conditional format rules panel that appears on the right side of the screen, click on the drop-down menu next to “Format cells if” and select “Custom formula is” from the options.
- In the input field next to “Value or formula,” enter the following formula:
B:Bwith the actual column range, you selected in Step 2, and
B1with the first cell of that range.)
- Click on the “Done” button. The duplicate values in the selected column or range will now be highlighted.