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

amazon logo

How to Change Language on Amazon from Spanish to English

May 29, 2023

5 Online Tools to Save You a Lot of Time

May 23, 2023
Photo by Pixabay on Pexels

How to Convert MKV Videos to MP4 using VideoProc Converter

May 22, 2023
Image by starline on Freepik

3 Proven Methods to Repair Corrupted AVI Files

May 18, 2023
Photo by Vlada Karpovich on Pexels

Top 5 Remote Access Solutions to Consider in 2023

May 16, 2023
MS Outlook logo

How to Switch from Mozilla Thunderbird to MS Outlook?

May 15, 2023
how to get the spotify widget on iPhone Lock Screen

iOS 16: How to Add Spotify Widget to iPhone Lock Screen

May 11, 2023

TRENDING

  • messenger icon at the top of Instagram app

    How to Reply to a Specific Message on Instagram 2022

  • How to Mute the Original Sound on Instagram Reels

  • How to See Memories on Instagram and Post as Story

  • 4 Ways to Remove the Floating Home Button on iPhone

  • How to Play Floating Cloud Game in Google Mobile Search

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.