Hero image

How to find duplicates in Google Sheets

3 min read

Summary

Identifying duplicates in Google Sheets helps maintain data accuracy and prevents redundancy, which is crucial for reliable analysis and decision-making.

Knowing how to find duplicates in Google Sheets is essential for managing data accuracy and eliminating redundant entries.

Google Sheets offers several methods to identify duplicates effectively. One of the simplest ways is by using the Conditional Formatting tool. Select the range of data, go to Format > Conditional Formatting.

Post image

Set a custom formula such as =COUNTIF(A:A, A1)>1. This highlights cells that contain duplicate values.

Post image

Alternatively, you can use the Data Cleanup tool in Google Sheets to quickly remove duplicates. Navigate to Data > Data cleanup > Remove duplicates, then select the data range you want to check. Specify whether to consider all columns or just specific ones to identify duplicates. The tool will scan your data and remove duplicate rows, leaving only unique entries.

Post image
More Google Workspace tips from Kanbanchi

Want to try the power of Kanbanchi and Google Workspace?

Start your free trial

Watch how to find duplicates in Google Sheets

Privacy Preference Center

Necessary

These cookies are necessary for Our Sites to function and cannot be switched off. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of Our Sites will not then work. These cookies do not store any personally identifiable information.

AADSSOTILES, access_token_production, amplitude_*, AMP_MKTG_*, amp_*, amp_*.organization.domain, ANONCHK, ar_debug, brcap, Ccs, CcsNtv, CCState, CcsWeb, cf_use_ob, ch, CkTst, CLID, clrc, cltm, CookieControl, deviceId, driftt_aid, ea, ec, el, ev, eventId, evt, fpc, gc, gv, identifyId, ifm, lastEventTime, lg, lt, mid, MR, msclkid, MSFPC, MSPTC, MUID, optOut, org_login_production, p, pi, r, rn, rrc, sc, sequenceNumber, sessionId, sh, sid, SM, SRM_*, sw, threxp, ti, tl, userId, ver, _biz_*, _clck, _clsk, _dc_gtm_UA-XXXXX-XX, _dc_gtm_*, _fbp, _ga, _gaexp, _gat, _gat_gtag_UA_*, _ga_XXXXXXXXXX, _ga_*, _gcl_au, _gid, _GRECAPTCHA, _mkto_trk, _rdt_uuid, _uet*, _zitok, __cfduid, __TAG_ASSISTANT, __utm*
cf_use_ob, __cfduid
ar_debug, _dc_gtm_UA-XXXXX-XX, _dc_gtm_*, _ga, _gaexp, _gat, _gat_gtag_UA_*, _ga_XXXXXXXXXX, _ga_*, _gcl_au, _gid, _GRECAPTCHA, __TAG_ASSISTANT, __utm*
access_token_production, amplitude_*, amp_*, CookieControl, deviceId, driftt_aid, eventId, identifyId, lastEventTime, optOut, org_login_production, sequenceNumber, sessionId, _uet*, userId, _biz_*, _fbp, _ga, _gid, _mkto_trk, _rdt_uuid, __utm*, _zitok
AADSSOTILES, brcap, Ccs, Ccs*, ch, CkTst, clrc, cltm, ea, ec, el, ev, evt, fpc, gc, gv, ifm, lg, lt, mid, msclkid, p, pi, r, rn, rrc, sc, sh, sid, sw, threxp, ti, tl, ver, _clck, _clsk, _uet*
MSFPC, MR, MSPTC, MUID, SRM_*
ANONCHK, MR, SM, CLID

Functionality

Functionality Cookies enable Us to provide enhanced functionality and personalisation. They may be set by Us or by third party providers whose services We have added to Our Sites. If you do not allow these cookies then some or all of these services may not function properly.

1P_JAR, 1_LIVE, ADS_VISITOR_ID, AEC, AID, APISID, APISID, DV, HSID, HSID, intercom-*, LOGIN_INFO, LSID, LSOLH, NID, OCAK, OGPC, OTZ, PREF, PSIDCC, SAPISID, SAPISID, SID, SID, SIDCC, SMSV, SOCS, SSID, SSID, VISITOR_*, YSC, __Secure-*
1_LIVE, APISID, HSID, LOGIN_INFO, PREF, SAPISID, SID, SSID, VISITOR_*, YSC
1P_JAR, ADS_VISITOR_ID, AEC, AID, APISID, DV, HSID, LSID, LSOLH, NID, OCAK, OGPC, OTZ, PSIDCC, SAPISID, SID, SIDCC, SMSV, SOCS, SSID, __Secure-*
intercom-*

Performance

Performance cookies allow Us to count visits and traffic sources so We can measure and improve the performance of Our Sites. They help Us to know which pages or features are the most and least popular and see how visitors move around Our Sites. If you do not allow these cookies We will not know when you have visited Our Sites, and will not be able to monitor their performance.

ajs_anonymous_id, csrf.app, hubspotutk, IR_PI, messagesUtk, .customer.io, _cfuvid, _cio, _cioanonid, _cioid, _conv_v, _ga, _ga_*, _hssc, _hssrc, _hstc, _ttp, _tt_enable_cookie, __cf_bm, __hssrc, __hstc, __hs_opt_out
csrf.app, hubspotutk, IR_PI, messagesUtk, _cfuvid, _conv_v, _hssc, _hssrc, _hstc, _ttp, _tt_enable_cookie, __cf_bm, __hssrc, __hstc, __hs_opt_out
ajs_anonymous_id, .customer.io, _cio, _cioanonid, _cioid, _ga, _ga_*

Targeting

These cookies may be set through Our Sites by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

AnalyticsSyncHistory, ar_debug, bcookie, Bizo*, bscookie, cb, ct0, datr, eu_cn, external_referer, fr, guest_id, guest_id_ads, guest_id_marketing, IDE, JSESSIONID, lang, lang, lidc, li_*, lms_ads, lms_analytics, ln_or, metrics_token, muc_ads, m-b, m-b_*, m-css_v, m-early_v, m-s, m-sa, m-tgvs, m-tz, m-uid, oribili_user_guid, oribi_cookie_test, personalization_id, sdsc, syndication_guest_id, test_cookie, tfw_exp, UID, UserMatchHistory, usida, wd, _fbp, _guid, _hj*, _twitter_sess
IDE, test_cookie
_hj*
cb, datr, fr, usida, wd, _fbp
ct0, eu_cn, external_referer, guest_id, guest_id_ads, guest_id_marketing, lang, metrics_token, muc_ads, personalization_id, syndication_guest_id, tfw_exp, _twitter_sess
m-b, m-b_*, m-css_v, m-early_v, m-s, m-sa, m-tgvs, m-tz, m-uid
AnalyticsSyncHistory, ar_debug, bcookie, Bizo*, bscookie, JSESSIONID, lang, lidc, li_*, lms_ads, lms_analytics, ln_or, oribili_user_guid, oribi_cookie_test, sdsc, UID, UserMatchHistory, _guid

Kanbanchi
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.