WebTrickz
TRENDING
  • How to See Your Liked Posts on Instagram 2023
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

reels on Instagram and Facebook

Here’s how to Copy Captions from Instagram Reels

November 7, 2023
opera gx gaming browser logo

How to Turn Off the Ad Blocker on Opera GX

November 3, 2023
chat lock on whatsapp

How to See Locked Chats in WhatsApp on iPhone and Android

November 1, 2023
instagram logo

How to Hide or Unhide Comments on Instagram 2023

November 7, 2023
Dynamic Island showing silent on iphone 15 pro max

How to Turn Silent Mode On or Off on iPhone 15 Pro & 15 Pro Max

November 28, 2023

How to Spoof Your Location on Monster Hunter Now on iPhone

September 21, 2023
iphone 15 pro max always-on display

How to Turn Off Always-On Display on iPhone 15 Pro & 15 Pro Max

September 19, 2023

TRENDING

  • assistive touch button on iPhone

    4 Ways to Remove the Floating Home Button on iPhone

  • How to Archive Orders and View Archived Orders on Amazon App

  • How to Turn Off & Restart iPhone 15, 15 Pro, and 15 Pro Max

  • Here’s How To Find Out When You Joined Snapchat

  • iOS 15: How to Turn Off Portrait mode in Snapchat on iPhone

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.