WebTrickz
TRENDING
  • How to Turn off Samsung Galaxy S21, S21+ and S21 Ultra
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 *

Latest Stories

a wifi router

How to find the best channel for my Wi-Fi?

January 22, 2021
Galaxy S21 lineup

How to Power Off & Restart Samsung Galaxy S21, S21+ and S21 Ultra

January 15, 2021
Bedtime in clock app on iphone

How to Turn Off Sleep Mode & Bedtime in iOS 14 on iPhone

January 8, 2021
MacBook desk

How to Lock/Unlock Notes with Touch ID on macOS Big Sur

January 5, 2021
macbook air m1 2020

How to Manually Adjust Keyboard Brightness on M1 MacBook Air

January 2, 2021

TRENDING

  • messenger icon at the top of Instagram app

    How to Reply to a Specific Message on Instagram 2020

  • What does Other Viewers mean on a Facebook Story?

  • How to Send Files and Documents on Messenger for Android

  • FAQs: Can I Remove Apps from App Library in iOS 14?

  • 3 Different Ways to Mark Spoilers on Discord

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.