• Tiếng ViệtTiếng Việt
Theo dõi
Follow
Home
  • Digital Marketing
    • Email Marketing
    • Facebook
    • Google Ads
    • Zalo Marketing
  • Website
    • SEO
    • Website measurement
    • WordPress
  • Technology
    • Computer tips
    • Mobile
    • Utilities
  • Review
  • Marketing tools
No Result
View All Result
Home
  • Digital Marketing
    • Email Marketing
    • Facebook
    • Google Ads
    • Zalo Marketing
  • Website
    • SEO
    • Website measurement
    • WordPress
  • Technology
    • Computer tips
    • Mobile
    • Utilities
  • Review
  • Marketing tools
No Result
View All Result
Home
No Result
View All Result

Lucid Gen › Technology › Computer tips › How to filter duplicate data in Google Sheets

How to filter duplicate data in Google Sheets

66
SHARES
6.6k
VIEWS
Chia sẻ bài viết lên Facebook

For Recruitment as well as other fields, we often use Google Forms to get candidate or customer data. The result will save to Google Sheets just like Excel is sure that data duplicates are inevitable. So how do I filter duplicate data in Google Sheets? Excel is easy to find online, but Google Sheets is different from filtering. Hieu will share with you in the first article of Minh Hieu HR page and of the sharing section in the industry.

Updated 28/02/2018: Filtering out data that appears 2 times onwards changes the way it is quick, accurate, easy to understand

filter duplicate data in Google Sheets
Filter duplicate data in Google Sheets

In the list above there are many names that overlap. We can find duplicate data and filter them in many ways, depending on your needs.

Related posts

  • How to create a YouTube channel subscription button on a video
  • How to use Grammarly software to correct English grammar
  • How to install Microsoft Office for free on a Macbook
Table of contents
  1. Highlight (find) duplicate data
  2. Filter out duplicate or non-duplicate data
  3. Filter out data that appears a second time onwards
  4. Links

Highlight (find) duplicate data

To find duplicate data in Google Sheets, we select the column that contains the data range. Click Format select Format by condition.

Highlight (find) duplicate data
Highlight (find) duplicate data

In the Conditional formatting rules table, we fill in the formula as shown below.

Fill in formulas
Fill in formulas

=Countif(A:A; A1)>1

Note: if the ” ; ” sign is not true for your machine, correct it to ” , ” okay. Edit the letter A to the text of the column you are formatting in your file.

So you have easily seen the duplicate data, next we will filter them. There are two ways to filter duplicate data in Google worksheets.

Filter out duplicate or non-duplicate data

Hieu inserted above a row to name it. In the cell next to the first, type the formula as shown below, and then drag the formula down to the full column.

Filter out duplicate or non-duplicate data
Filter out duplicate or non-duplicate data

=countif(A:A; A2)=1

At this time TRUE is the data is not duplicated, and FALSE is the duplicate data. We click on the number 1 sequence to select the name range, click Data, and select Filter.

Click the number 1 sequence to select the name range, click Data, and select Filter
Click the number 1 sequence to select the name range, click Data, and select Filter

Next click the filter button. Now that we want to see that the data doesn’t match, we keep TRUE, and if we want to see the data overlap, we keep FALSE.

If you don't overlap, you keep TRUE, you keep false.
If you don’t overlap, you keep TRUE, you keep false.

And the result is obtained when we retain TRUE – the data does not coincide.

Results obtained when we retain TRUE
Results obtained when we retain TRUE

But this way is not optimal. We can only see duplicates or not duplicates. What we dream of is a complete list of data, filtering away only the data that is repeated 2 times or more. Hieu assured this is the first article to appear on Google to help you do this. Haha

Filter out data that appears a second time onwards

Selecting the first cell next to the column containing the data, Hieu selects column B, the corresponding A2 will be B2. In this cell you fill in the formula as shown in the image below.

Filter out data that appears a second time onwards
Filter out data that appears a second time onwards

So the cells repeating the second time onwards will change to Tranngocminhhieu.com

=if(countif($A $2:A2; A2)=1; A2;” Tranngocminhhieu.com”)

Explain:

$A$2: is to fix unchanged

A2: will change when pulled down

“Tranngocminhhieu.com”: Whatever you want to write

Now to filter the data that appears for the first time, then add the filter button > un-select Tranngocminhhieu.com > OK

Unsymed Tranngocminhhieu.com is to remove repetitive data
Unsymed Tranngocminhhieu.com is to remove repetitive data

Great yet, hehe

The results of filtering the data are not duplicated
The results of filtering the data are not duplicated

As a result, you already have a full list of data, less to lose any data and not duplicate any data. You can also see which doses have duplicates in the highlighted cell.

Links

That’s wonderful, isn’t it? With the last filtering will help you do a lot of work, such as emailing or bulk messaging is too much. This is minh Hieu HR’s first article, how do you feel and how difficult it is to leave a comment.

5 / 5 ( 1 vote )
Share26Pin6Share5
Next Post

How to create a list of tables by chapter in Word

How to create an automatic table of contents in Word with heading

Compare the difference between B2B and B2C markets

Leave a Reply Cancel reply

I will review and reply to all comments within the day. Please feel free to leave your comments on this article!

Your email address will not be published. Required fields are marked *

You will probably need it

Cách viết chữ in đậm trên Facebook và FB chat
Facebook

How to write bold text on Facebook and FB Messenger

18/10/2020
0

How to write type on Facebook, write in bold, italic on Facebook, change the FB font on status. 100% of...

Read more

Recommend for you

  • Trending
  • Latest
Cách viết chữ in đậm trên Facebook và FB chat

How to write bold text on Facebook and FB Messenger

18/10/2020
Cách dùng Authenticator trên điện thoại và máy tính

How to use Google Authenticator on PC desktop

18/10/2020

How to target your competitor customers on Facebook Ads

12/12/2020

How to book an appointment on Facebook fanpage

18/10/2020
Chia sẻ và hướng dẫn Wordfence Security Premium

How to set up Wordfence Security Premium plugin

12/12/2020
Cách tạo nút đăng ký kênh YouTube trên video

How to create a YouTube channel subscription button on a video

12/12/2020
Cách cấu hình Contact Form 7 kết nối với Google Sheet

How to set up Contact Form 7 to connect to Google Sheet

18/10/2020
Cách dùng phần mềm sửa lỗi ngữ pháp tiếng Anh Grammarly

How to use Grammarly software to correct English grammar

12/12/2020

Home

Một blog chia sẻ về digital marketing, linh tinh về công nghệ và những gì có thể bạn cần mà tác giả biết.

Phát triển bởi một người thích viết blog
Trần Ngọc Minh Hiếu
› Donate cho tác giả

Thống kê thời gian thực đã có 63 Bài viết và 2,435 Bình luận

Tiết lộ: Website này đã có quảng cáo. Không có tiền thì viết làm sao.

Recent Comments

  • AR on How to install Microsoft Office for free on a Macbook
  • Minh Hiếu on How to merge multiple Excel and CSV files into 1 sheet
  • Nguyenthoa on How to merge multiple Excel and CSV files into 1 sheet
  • Minh Hiếu on How to merge multiple Excel and CSV files into 1 sheet
  • Nguyenthoa on How to merge multiple Excel and CSV files into 1 sheet

Image sources

Lucid Gen edits images from the following sources: Freepik, Unsplash & Pixabay.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

  • About
  • Contact
  • Terms and policies

© 2019 Lucid Gen with by Minh Hieu DMCA Protected

No Result
View All Result
  • Digital Marketing
    • Email Marketing
    • Facebook
    • Google Ads
    • Zalo Marketing
  • Website
    • SEO
    • Website measurement
    • WordPress
  • Technology
    • Computer tips
    • Mobile
    • Utilities
  • Review
  • Marketing tools

© 2019 Lucid Gen with by Minh Hieu DMCA Protected