WebTrickz
TRENDING
  • How to Find Birthdays on Facebook App 2021
No Result
View All Result
  • News
  • Reviews
  • Social Media
    • Facebook
    • Twitter
    • YouTube
    • Messenger
    • Instagram
    • Snapchat
    • WhatsApp
    • TikTok
  • Apps
  • How To’s
  • Apple
  • iPhone
  • Google
  • Android
  • Mac
SUBSCRIBE
  • News
  • Reviews
  • Social Media
    • Facebook
    • Twitter
    • YouTube
    • Messenger
    • Instagram
    • Snapchat
    • WhatsApp
    • TikTok
  • Apps
  • How To’s
  • Apple
  • iPhone
  • Google
  • Android
  • Mac
No Result
View All Result
WebTrickz
No Result
View All Result
Home Google

Google Sheets adds native Remove Duplicates functionality

Mayur Agarwal by Mayur Agarwal
December 19, 2019
in Google, News, Productivity
Remove Duplicates feature comes to Google Sheets

Google Sheets is undoubtedly the best and most powerful alternative to Microsoft Excel. Unlike MS Excel, Google Sheets lacks the crucial functionality to natively remove duplicate or repeated entries. Fortunately, Google has now added a new feature that lets you easily remove duplicate values from your sheet. This was a highly requested feature that Sheets users have been waiting since forever. Until now, users have to resort to using an add-on, Google Apps Script, or UNIQUE function just to remove duplicate data.

With the help of built-in “Remove Duplicates” option, you can now filter unique values in a few clicks and without using any cumbersome workaround. This new function will significantly ease your work and will save you a lot of time. Basic users, on the other hand now won’t find the need to move back to Excel just to remove duplicate entries from their sheet.

How to Remove Duplicates in Google Sheets

  1. Select a range of data in your sheet, generally rows and columns.
  2. Click Data > Remove duplicates from the toolbar.
  3. A dialogue box will show the range of data selected by you.
  4. Select Remove duplicates to confirm.

A new dialogue box will now appear listing details about the number of duplicate values removed from your dataset.

The said feature will be available for G Suite customers as well as the general public. It will be supported in Apps Script, macro recording, and one platform APIs in early June 2019.

Availability & Rollout Details –

  • Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 8, 2019
  • Scheduled Release domains: Full rollout (1-3 days for feature visibility) starting on May 22, 2019

Talking of duplicate data, it is nearly impossible to avoid duplicate entries or records when you are dealing with lots of data in a spreadsheet. Duplicate values usually occur due to human error and sorting duplicate data entries manually may not be practical if you’re into serious work.

Source: G Suite Updates Blog
Via: @CyrusShepard
Tags: GoogleGoogle Docs
Share2TweetSend
Previous Post

How to Take a Screenshot on OnePlus 7 and 7 Pro

Next Post

How to Find Archived Emails in Gmail

Mayur Agarwal

Mayur Agarwal

Mayur Agarwal is the founder and editor-in-chief of WebTrickz. As a Technology enthusiast and an Internet addict, he loves sharing useful How To’s and Tips & Tricks.

Next Post

How to Find Archived Emails in Gmail

Leave a Reply Cancel reply

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

ADVERTISEMENT

Latest Stories

messenger new logo

How to Undo Ignore Messages on Messenger without replying

April 19, 2021

How to Restrict Someone on Facebook 2021 without blocking them

April 16, 2021
galaxy a52

How to Record Screen on Samsung Galaxy A52 and A72

April 13, 2021
galaxy S8

How to Hide Status Bar Icons on Samsung Galaxy Phones

April 8, 2021

How to Stop Live Video Notifications for One Person on Instagram

March 22, 2021

TRENDING

  • messenger icon at the top of Instagram app

    How to Reply to a Specific Message on Instagram 2020

  • How to Send Files and Documents on Messenger for Android

  • Here’s how to Change your Age on Discord

  • How to Sign Out of One Google Account on your Computer

  • What does Other Viewers mean on a Facebook Story?

ADVERTISEMENT

Popular Tags

Google Android Chrome

Twitter Dark Mode OnePlus

iPhone Apple Apps Mac

Facebook Messenger Security

Instagram Tutorials Photos

  • About
  • Advertise
  • Contact
  • Privacy Policy

© 2021 WebTrickz. All Rights Reserved.

No Result
View All Result
  • News
  • Reviews
  • Apps
  • How To’s
  • Android
  • Google
  • iPhone
  • Mac
  • Contact Us

© 2021 WebTrickz. All Rights Reserved.