WebTrickz
TRENDING
  • How to See Your Liked Posts on Instagram 2022
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 on iPhone and Android

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 on iPhone and Android

Leave a Reply Cancel reply

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

Latest Stories

Facebook app on iPhone

How to Find Block List on Facebook App [2023]

January 20, 2023

AimerLab MobiGo Review 2023: An effective Location Changer for iOS

January 14, 2023
whatsapp logo

How to Restore Deleted WhatsApp Messages Without Backup

December 30, 2022
story comments on facebook

How to Turn Off Story Comments on Facebook

December 3, 2022
Photo by Alwin Kroon on Unsplash

How to Turn Vibrate On or Off in iOS 16 on iPhone 

November 25, 2022
reels on Instagram and Facebook

Here’s how you can See Reels Views on Facebook

November 23, 2022

7 Best Free Online Puzzles To Enjoy At Home

November 21, 2022

TRENDING

  • Facebook saved reels

    How to Find Your Saved and Liked Reels on Facebook

  • How to Reply to a Specific Message on Instagram 2022

  • How to Mute the Original Sound on Instagram Reels

  • How to Make Spotify Album Art Bigger on iOS 16 Lock Screen

  • How to Send Files and Documents on Messenger for Android

Popular Tags

Google Android Chrome

Twitter Dark Mode OnePlus

iPhone Apple Apps Mac

Facebook Messenger Security

Instagram Tutorials Photos

  • About
  • Advertise
  • Contact
  • Privacy Policy

© 2023 WebTrickz. All Rights Reserved.

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

© 2023 WebTrickz. All Rights Reserved.