{"id":38583,"date":"2026-09-29T09:48:39","date_gmt":"2026-09-29T08:48:39","guid":{"rendered":"https:\/\/keyfy.com\/blog\/cum-sa-eliminati-in-siguranta-datele-duplicate-din-excel\/"},"modified":"2026-09-29T09:52:52","modified_gmt":"2026-09-29T08:52:52","slug":"cum-sa-eliminati-in-siguranta-datele-duplicate-din-excel","status":"publish","type":"post","link":"https:\/\/keyfy.com\/ro\/blog\/cum-sa-eliminati-in-siguranta-datele-duplicate-din-excel\/","title":{"rendered":"Cum s\u0103 elimina\u021bi \u00een siguran\u021b\u0103 datele duplicate din Excel"},"content":{"rendered":"<p>Imagina\u021bi-v\u0103 un contabil care are un fi\u0219ier exportat <strong>cu 12.000 de r\u00e2nduri<\/strong> reprezent\u00e2nd comenzile clien\u021bilor. Doi clien\u021bi au acela\u0219i nume de familie, c\u00e2teva comenzi se repet\u0103 deoarece exportul s-a rulat de dou\u0103 ori, iar printre acestea se afl\u0103 \u0219i \u00eenregistr\u0103ri care doar <em>par<\/em> a fi duplicate. Ea selecteaz\u0103 \u00eentreaga foaie, d\u0103 clic pe \u201eEliminare duplicate\u201d, iar Excel raporteaz\u0103 cu entuziasm: \u201e347 de valori duplicate g\u0103site \u0219i eliminate\u201d. Totul se face \u00een c\u00e2teva secunde. Doar c\u0103 aproximativ 90 dintre acestea nu erau deloc duplicate, iar acum au disp\u0103rut.    <\/p>\n<p>Asta e capcana. <strong>Procesul de eliminare<\/strong> \u00een siguran\u021b\u0103 <strong>a duplicatelor din Excel<\/strong> \u00eencepe \u00eenainte chiar de a ap\u0103sa butonul. <strong>Func\u021bia \u201eEliminare duplicate\u201d<\/strong> ac\u021bioneaz\u0103 rapid, are efect permanent \u0219i nu ofer\u0103 nicio indica\u021bie cu privire la ce anume compar\u0103 de fapt.<\/p>\n<p>Majoritatea ghidurilor trec direct la acel buton. Ceea ce omit este partea care \u00ee\u021bi salveaz\u0103 datele: verific\u0103 \u00eenainte de a \u0219terge. Selecteaz\u0103 mai \u00eent\u00e2i, verific\u0103 ce consider\u0103 Excel c\u0103 este un duplicat, apoi \u0219terge. A\u0219adar, hai s\u0103 parcurgem pa\u0219ii cum trebuie.   <\/p>\n<div class=\"pb-tldr\" style=\"background: #eef2ff; border-left: 4px solid #007aff; border-radius: 8px; padding: 16px 20px; margin: 24px 0;\">\n<div style=\"font-weight: bold; color: #4f46e5; font-size: 13px; letter-spacing: 1.5px; margin-bottom: 6px;\">Rezumat rapid (TLDR)<\/div>\n<div style=\"color: #1f2937;\">Faptul c\u0103 pierzi sau nu date valoroase atunci c\u00e2nd elimini duplicatele \u00een Excel depinde de dou\u0103 lucruri: ce coloane selectezi \u0219i dac\u0103 ai verificat potrivirile \u00eenainte de \u0219tergere. Mai \u00eent\u00e2i, eviden\u021bia\u021bi duplicatele cu ajutorul <strong>format\u0103rii condi\u021bionale<\/strong>, astfel \u00eenc\u00e2t s\u0103 le pute\u021bi vedea, confirma\u021bi c\u0103 selec\u021bia coloanelor reflect\u0103 ceea ce \u00eenseamn\u0103 de fapt \u201eduplicat\u201d pentru datele dvs., apoi \u0219terge\u021bi. Func\u021bia \u201eEliminare duplicate\u201d este permanent\u0103 \u0219i nu afi\u0219eaz\u0103 niciun avertisment de anulare odat\u0103 ce \u00eenchide\u021bi fi\u0219ierul.  <\/div>\n<\/div>\n<h2>De ce sfaturile obi\u0219nuite \u00eei cost\u0103 pe oameni datele lor<\/h2>\n<p>Majoritatea tutorialelor se rezum\u0103 la vreo trei propozi\u021bii. Selecteaz\u0103 datele, acceseaz\u0103 fila \u201eDate\u201d, apoi d\u0103 clic pe \u201eEliminare duplicate\u201d. Din punct de vedere tehnic, este corect. Din punct de vedere practic, este periculos.   <\/p>\n<p>Aici se acumuleaz\u0103 dou\u0103 probleme. \u00cen primul r\u00e2nd, ac\u021biunea este distructiv\u0103. Excel nu mut\u0103 duplicatele \u00eentr-o foaie separat\u0103 \u0219i nici nu le marcheaz\u0103 pentru verificare \u2013 \u0219terge r\u00e2ndurile \u0219i deplaseaz\u0103 totul mai sus. Dac\u0103 salva\u021bi \u0219i \u00eenchide\u021bi, a doua zi diminea\u021b\u0103 nu ve\u021bi mai avea la dispozi\u021bie op\u021biunea de a anula opera\u021biunea.   <\/p>\n<p>\u00cen al doilea r\u00e2nd, \u0219i acesta este aspectul pe care nimeni nu \u00eel explic\u0103, coloanele pe care le bifa\u021bi \u00een fereastra de dialog determin\u0103 ce anume este considerat duplicat. Aceast\u0103 singur\u0103 alegere schimb\u0103 \u00eentregul rezultat. Dac\u0103 bifa\u021bi doar coloana \u201eE-mail\u201d, Excel trateaz\u0103 dou\u0103 r\u00e2nduri ca fiind identice dac\u0103 adresele de e-mail se potrivesc, chiar \u0219i atunci c\u00e2nd numele, datele comenzilor \u0219i sumele sunt complet diferite. P\u0103streaz\u0103 primul r\u00e2nd, elimin\u0103 restul, iar comenzile reale dispar.   <\/p>\n<p>Chiar \u0219i \u00een propriile instruc\u021biuni, Microsoft recunoa\u0219te c\u0103 eliminarea duplicatelor duce la \u0219tergerea definitiv\u0103 a datelor, motiv pentru care <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552dc138d\" rel=\"nofollow noopener\" target=\"_blank\">serviciul de asisten\u021b\u0103 Microsoft recomand\u0103 copierea intervalului de celule \u00eentr-o alt\u0103 foaie de calcul<\/a> \u00eenainte de a rula instrumentul. Un obicei bun. Aproape nimeni nu \u00eel respect\u0103.  <\/p>\n<div class=\"pb-tipbox pb-tipbox-warning\" style=\"background: #fffbeb; border-left: 4px solid #f59e0b; border-radius: 8px; padding: 14px 18px; margin: 24px 0;\">\n<div style=\"font-weight: bold; color: #b45309; font-size: 13px; letter-spacing: 1px; margin-bottom: 5px;\">AVERTISMENT<\/div>\n<div style=\"color: #1f2937;\">Cum s\u0103 elimina\u021bi \u00een siguran\u021b\u0103 duplicatele din Excel: marca\u021bi, verifica\u021bi, apoi \u0219terge\u021bi<\/div>\n<\/div>\n<p>Iat\u0103 metoda care \u00ee\u021bi protejeaz\u0103 cu adev\u0103rat datele. Dureaz\u0103 poate dou\u0103 minute \u00een plus, dar \u00eenseamn\u0103 c\u0103 nu se \u0219terge nimic f\u0103r\u0103 s\u0103 ai ocazia s\u0103 vezi mai \u00eent\u00e2i. <\/p>\n<h3>Pasul 1 \u2013 Identificarea valorilor duplicate \u00een Excel cu ajutorul format\u0103rii condi\u021bionale<\/h3>\n<p>\u00cenainte de a efectua orice opera\u021biune care ar putea duce la pierderi de date, face\u021bi vizibile valorile duplicate. Selecta\u021bi intervalul dorit, apoi accesa\u021bi meniul \u201eAcas\u0103\u201d (Home) &gt; \u201eFormatare condi\u021bionat\u0103\u201d (Conditional Formatting) &gt; \u201eReguli de eviden\u021biere a celulelor\u201d (Highlight Cells Rules) &gt; \u201eValori duplicate\u201d (Duplicate Values). Alege\u021bi o culoare de umplere \u0219i confirma\u021bi.  <\/p>\n<p>Excel eviden\u021biaz\u0103 fiecare valoare duplicat\u0103. Este cea mai rapid\u0103 metod\u0103 de a identifica duplicatele f\u0103r\u0103 a modifica nicio celul\u0103, iar opera\u021biunea este complet reversibil\u0103. Nu \u00ee\u021bi place ce vezi? \u0218terge regula. Nu s-a modificat nimic.    <\/p>\n<p>Un aspect important de re\u021binut \u00een leg\u0103tur\u0103 cu func\u021bia de eviden\u021biere: aceasta func\u021bioneaz\u0103 coloan\u0103 cu coloan\u0103, indiferent de celulele selectate. Dac\u0103 eviden\u021bia\u021bi o singur\u0103 coloan\u0103, Excel va marca valorile repetate numai \u00een acea coloan\u0103. Dac\u0103 eviden\u021bia\u021bi mai multe coloane, fiecare celul\u0103 este tratat\u0103 independent, ceea ce poate p\u0103rea aglomerat, dar v\u0103 indic\u0103 exact unde se afl\u0103 repeti\u021biile.  <\/p>\n<h3>Pasul 2 \u2013 Verifica\u021bi \u00eenainte de a salva<\/h3>\n<p>Parcurge\u021bi celulele eviden\u021biate. Acesta este pasul pe care contabilul l-a omis. \u00centreba\u021bi-v\u0103 dac\u0103 o valoare eviden\u021biat\u0103 este \u00eentr-adev\u0103r un r\u00e2nd duplicat sau doar o valoare care se repet\u0103 \u00een mod legitim. Dou\u0103 persoane diferite numite \u201eJames Miller\u201d vor ap\u0103rea am\u00e2ndou\u0103 eviden\u021biate dac\u0103 selecta\u021bi coloana cu numele. Niciuna dintre ele nu reprezint\u0103 o comand\u0103 duplicat\u0103.    <\/p>\n<p>Aceast\u0103 verificare \u00ee\u021bi permite s\u0103 faci diferen\u021ba \u00eentre \u201eaceast\u0103 valoare apare de dou\u0103 ori\u201d \u0219i \u201e\u00eentregul \u00eenregistrare este o copie\u201d. Nu este deloc acela\u0219i lucru \u2013 iar func\u021bia \u201eEliminare duplicate\u201d ia \u00een considerare doar coloanele pe care i le furnizezi. <\/p>\n<h3>Pasul 3: \u0218terge\u021bi, cu coloanele potrivite selectate<\/h3>\n<p>Acum \u0219tergi \u0219i \u0219tii exact ce \u0219tergi. Selecteaz\u0103 datele, acceseaz\u0103 fila \u201eDate\u201d, apoi op\u021biunea \u201eEliminare duplicate\u201d. Fereastra de dialog afi\u0219eaz\u0103 fiecare coloan\u0103 \u00eenso\u021bit\u0103 de o caset\u0103 de selectare. Aceast\u0103 fereastr\u0103 de dialog este esen\u021bial\u0103.   <\/p>\n<h2>Cum alegerea coloanei schimb\u0103 totul<\/h2>\n<p>Aceasta este partea pe care majoritatea concuren\u021bilor o omit cu totul, a\u0219a c\u0103 hai s\u0103 analiz\u0103m cu aten\u021bie ce se \u00eent\u00e2mpl\u0103.<\/p>\n<p>Atunci c\u00e2nd se elimin\u0103 \u00eenregistr\u0103rile duplicate din mai multe coloane, Excel \u0219terge un r\u00e2nd numai atunci c\u00e2nd <em>fiecare coloan\u0103 bifat\u0103<\/em> se potrive\u0219te exact cu un alt r\u00e2nd. Dac\u0103 bifa\u021bi toate coloanele, un r\u00e2nd trebuie s\u0103 fie o copie identic\u0103 \u00eenainte de a fi eliminat. Aceasta este setarea cea mai sigur\u0103, deoarece nu elimin\u0103 aproape niciodat\u0103 o \u00eenregistrare care difer\u0103 \u00een vreun mod semnificativ.  <\/p>\n<p>Dac\u0103 debifezi coloanele, defini\u021bia devine mai pu\u021bin strict\u0103. S\u0103 presupunem c\u0103 datele tale con\u021bin \u201eNume\u201d, \u201eE-mail\u201d, \u201eID comand\u0103\u201d \u0219i \u201eSum\u0103\u201d. Iat\u0103 cum se comport\u0103 acela\u0219i buton \u00een func\u021bie de ce bifezi:  <\/p>\n<div style=\"margin: 24px 0;\">\n<table class=\"pb-table\" style=\"width: 100%; border-collapse: separate; border-spacing: 0; font-size: 15px; line-height: 1.55; border: 1px solid #e5e7eb; border-radius: 10px;\">\n<thead>\n<tr>\n<th style=\"background: #4f46e5; color: #ffffff; text-align: left; padding: 12px 16px; font-weight: 600; border-top-left-radius: 9px;\">Coloanele bifate<\/th>\n<th style=\"background: #4f46e5; color: #ffffff; text-align: left; padding: 12px 16px; font-weight: 600;\">Ce consider\u0103 Excel a fi un duplicat<\/th>\n<th style=\"background: #4f46e5; color: #ffffff; text-align: left; padding: 12px 16px; font-weight: 600; border-top-right-radius: 9px;\">Nivelul de risc<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">Toate cele patru coloane<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">Doar r\u00e2ndurile identice \u00een fiecare c\u00e2mp<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">Nivel sc\u0103zut \u2013 cel mai sigur<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">Nume + E-mail<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">R\u00e2nduri care corespund dup\u0103 nume \u0219i e-mail, ignor\u00e2nd detaliile comenzii<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">Mediu<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">Doar e-mail<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">Orice r\u00e2nduri care au aceea\u0219i adres\u0103 de e-mail, restul sunt ignorate<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">Nivel ridicat \u2013 \u0219terge comenzile distincte<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">Doar ID-ul comenzii<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">R\u00e2nduri cu acela\u0219i ID, chiar dac\u0103 au fost reintroduse \u00een mod real<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">Mediu-ridicat<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Observa\u021bi tiparul. Cu c\u00e2t sunt bifate mai pu\u021bine coloane, cu at\u00e2t \u0219tergerea este mai radical\u0103. Oricine dore\u0219te s\u0103 p\u0103streze fiecare comand\u0103 distinct\u0103 ar trebui s\u0103 bifeze toate coloanele care fac ca un r\u00e2nd s\u0103 fie unic, \u00een timp ce cineva care cur\u0103\u021b\u0103 o simpl\u0103 list\u0103 de distribu\u021bie poate bifa \u00een siguran\u021b\u0103 doar coloana \u201eE-mail\u201d \u2013 o adres\u0103 de e-mail repetat\u0103 reprezint\u0103 \u00eentr-adev\u0103r un contact duplicat \u00een acest context.  <\/p>\n<p>Regula general\u0103: bifa\u021bi coloanele care, luate \u00eempreun\u0103, definesc o \u00eenregistrare unic\u0103. \u00cen cazul comenzilor, acestea sunt de obicei ID-ul comenzii plus c\u00e2teva c\u00e2mpuri. Pentru o list\u0103 de contacte, ar putea fi doar adresa de e-mail.  <\/p>\n<div class=\"pb-stats\" style=\"display: flex; gap: 14px; flex-wrap: wrap; margin: 24px 0;\">\n<div style=\"flex: 1; min-width: 150px; background: #f9fafb; border: 1px solid #e5e7eb; border-radius: 10px; padding: 18px 14px; text-align: center;\">\n<div style=\"font-size: 13px; color: #6b7280; margin-top: 6px;\">## Ob\u021binerea valorilor unice f\u0103r\u0103 a \u0219terge nimic<\/div>\n<\/div>\n<\/div>\n<p>Uneori nu vrei deloc s\u0103 distrugi originalul. Vrei doar s\u0103 prime\u0219ti separat o list\u0103 curat\u0103 cu valori unice. Exist\u0103 dou\u0103 modalit\u0103\u021bi sigure de a face acest lucru.  <\/p>\n<p><strong>Func\u021bia UNIQUE<\/strong> este cea mai simpl\u0103 solu\u021bie, dac\u0103 versiunea ta de Excel o suport\u0103. Introdu-o \u00eentr-o celul\u0103 goal\u0103 \u0219i aceasta va genera o list\u0103 f\u0103r\u0103 duplic\u0103ri \u00een celulele \u00eenvecinate, f\u0103r\u0103 a modifica sursa. <\/p>\n<pre><code>=UNIQUE(A2:A5000)\n<\/code><\/pre>\n<p>Datele originale r\u0103m\u00e2n exact acolo unde sunt. Modifica\u021bi sursa, iar lista unic\u0103 se actualizeaz\u0103 automat. Acesta este marele avantaj fa\u021b\u0103 de func\u021bia \u201eEliminare duplicate\u201d \u2013 este o opera\u021biune nedistructiv\u0103 prin natura sa.  <\/p>\n<p>Cealalt\u0103 op\u021biune este <strong>\u201eFiltru avansat<\/strong>\u201d. Data &gt; Advanced &gt; \u201eCopiere \u00eentr-o alt\u0103 loca\u021bie\u201d cu op\u021biunea \u201eNumai \u00eenregistr\u0103ri unice\u201d bifat\u0103. Aceasta creeaz\u0103 o copie f\u0103r\u0103 duplic\u0103ri \u00een alt\u0103 parte a foii de calcul. <a href=\"https:\/\/www.exceldemy.com\/8-ways-to-remove-duplicates-in-excel-without-losing-data\/\" rel=\"nofollow noopener\" target=\"_blank\">ExcelDemy prezint\u0103 mai multe metode nedistructive<\/a>, dac\u0103 dori\u021bi variante, iar <a href=\"https:\/\/www.datacamp.com\/tutorial\/remove-duplicates-excel\" rel=\"nofollow noopener\" target=\"_blank\">DataCamp trateaz\u0103 mai \u00een detaliu abordarea bazat\u0103 pe func\u021bia UNIQUE<\/a>. Ambele men\u021bin sursa intact\u0103, ceea ce este esen\u021bial.   <\/p>\n<h2>Solu\u021bionarea problemelor legate de capcanele obi\u0219nuite<\/h2>\n<p>Exist\u0103 c\u00e2teva aspecte care le dau b\u0103t\u0103i de cap oamenilor, chiar \u0219i atunci c\u00e2nd respect\u0103 ordinea.<\/p>\n<p><strong>\u201eMi-a \u0219ters r\u00e2ndurile de care aveam nevoie.\u201d<\/strong>  Aproape \u00eentotdeauna este vorba de o problem\u0103 legat\u0103 de selectarea coloanelor. Ai bifat prea pu\u021bine coloane, a\u0219a c\u0103 Excel a f\u0103cut potrivirea pe baza unor date par\u021biale. Nu ai salvat \u0219i nu ai \u00eenchis fi\u0219ierul? Apas\u0103 imediat Ctrl+Z. Ai \u00eenchis deja fi\u0219ierul? Atunci vei folosi o copie de rezerv\u0103. Tocmai de aceea este important s\u0103 ai obiceiul de a salva mai \u00eent\u00e2i.      <\/p>\n<p><strong>Duplicatele care nu sunt depistate.<\/strong>  De obicei, spa\u021bii la sf\u00e2r\u0219itul cuvintelor sau utilizarea inconsecvent\u0103 a majusculelor. Din punctul de vedere al Excel, \u201ejohn@mail.com \u201d cu un spa\u021biu nu este echivalent cu \u201ejohn@mail.com\u201d. Aplica\u021bi mai \u00eent\u00e2i func\u021biile TRIM \u0219i CLEAN pe coloan\u0103; \u00een caz contrar, etapa de eviden\u021biere nu le va detecta.  <\/p>\n<p><strong>Numere stocate sub form\u0103 de text.<\/strong>  O valoare formatat\u0103 ca text \u0219i aceea\u0219i valoare sub form\u0103 de num\u0103r nu se vor potrivi. Converti\u021bi coloana \u00eentr-un singur format uniform \u00eenainte de a elimina duplicatele; \u00een caz contrar, ve\u021bi ob\u021bine rezultate false negative. <\/p>\n<p><strong>Celulele combinate genereaz\u0103 erori.<\/strong>  Func\u021bia \u201eEliminare duplicate\u201d nu func\u021bioneaz\u0103 pe intervale care con\u021bin celule \u00eembinate. Desface\u021bi mai \u00eent\u00e2i \u00eembinarea. <\/p>\n<div class=\"pb-tipbox pb-tipbox-tip\" style=\"background: #ecfdf5; border-left: 4px solid #10b981; border-radius: 8px; padding: 14px 18px; margin: 24px 0;\">\n<div style=\"font-weight: bold; color: #047857; font-size: 13px; letter-spacing: 1px; margin-bottom: 5px;\">SFAT<\/div>\n<div style=\"color: #1f2937;\">## \u00centreb\u0103ri frecvente<\/div>\n<\/div>\n<p><strong>Eliminarea duplicatelor \u00een Excel \u0219terge \u00eentregul r\u00e2nd sau doar celula respectiv\u0103?<\/strong><br \/>\n\u00centregul r\u00e2nd. Excel \u0219terge \u00eentregul \u00eenregistrare \u0219i deplaseaz\u0103 r\u00e2ndurile de dedesubt \u00een sus. Nu gole\u0219te niciodat\u0103 o singur\u0103 celul\u0103, motiv pentru care selectarea coloanelor este at\u00e2t de important\u0103 \u2013 potrivirea se face pe coloane, dar \u0219tergerea se face pe r\u00e2nduri.  <\/p>\n<p><strong>\u00cemi pot recupera datele dup\u0103 ce elimin duplicatele?<\/strong><br \/>\nDoar folosind Ctrl+Z \u00eenainte de a salva \u0219i a \u00eenchide fi\u0219ierul sau dintr-o copie de rezerv\u0103 salvat\u0103. Odat\u0103 ce fi\u0219ierul este \u00eenchis, nu mai exist\u0103 nicio posibilitate de recuperare. Copia\u021bi mai \u00eent\u00e2i intervalul selectat \u00eentr-o alt\u0103 foaie de calcul, ca m\u0103sur\u0103 de siguran\u021b\u0103.  <\/p>\n<p><strong>Cum pot eviden\u021bia valorile duplicate \u00een loc s\u0103 le \u0219terg?<\/strong><br \/>\nPagina principal\u0103 &gt; Formatare condi\u021bionat\u0103 &gt; Reguli de eviden\u021biere a celulelor &gt; Valori duplicate. Aceast\u0103 func\u021bie coloreaz\u0103 fiecare valoare repetat\u0103 f\u0103r\u0103 a modifica datele, iar regula poate fi dezactivat\u0103 oric\u00e2nd. Este cea mai sigur\u0103 metod\u0103 de identificare a valorilor duplicate oferit\u0103 de Excel.  <\/p>\n<p><strong>Care este diferen\u021ba dintre op\u021biunile \u201eUNIQUE\u201d \u0219i \u201eRemove Duplicates\u201d?<\/strong><br \/>\nUNIQUE este o formul\u0103 care genereaz\u0103 o list\u0103 separat\u0103 de valori unice, calculat\u0103 \u00een timp real, f\u0103r\u0103 a modifica sursa. Func\u021bia \u201eEliminare duplicate\u201d modific\u0103 definitiv datele \u00een loc. Folosi\u021bi UNIQUE atunci c\u00e2nd dori\u021bi s\u0103 p\u0103stra\u021bi originalul.  <\/p>\n<p><strong>Cum pot elimina duplicatele din mai multe coloane?<\/strong><br \/>\n\u00cen fereastra de dialog, bifa\u021bi fiecare coloan\u0103 care, \u00eempreun\u0103 cu celelalte, define\u0219te o \u00eenregistrare unic\u0103. Excel \u0219terge un r\u00e2nd numai atunci c\u00e2nd toate coloanele bifate se potrivesc exact cu cele dintr-un alt r\u00e2nd. Cu c\u00e2t sunt bifate mai multe coloane, cu at\u00e2t opera\u021biunea este mai sigur\u0103; cu c\u00e2t sunt bifate mai pu\u021bine, cu at\u00e2t opera\u021biunea este mai agresiv\u0103.  <\/p>\n<h2>Versiunea scurt\u0103<\/h2>\n<p>Func\u021bia \u201eEliminare duplicate\u201d nu este du\u0219manul. Problema este s\u0103 o folose\u0219ti f\u0103r\u0103 s\u0103 verifici. Eviden\u021bia\u021bi duplicatele cu ajutorul format\u0103rii condi\u021bionale, astfel \u00eenc\u00e2t s\u0103 le pute\u021bi vedea cu adev\u0103rat, verifica\u021bi dac\u0103 sunt duplicatele reale sau doar valori repetate, apoi \u0219terge\u021bi-le bif\u00e2nd coloanele corespunz\u0103toare. \u0218i copia\u021bi \u00eentotdeauna datele \u00eentr-o alt\u0103 foaie de calcul \u00eenainte, deoarece instrumentul nu ofer\u0103 o a doua \u0219ans\u0103 odat\u0103 ce fi\u0219ierul este \u00eenchis.   <\/p>\n<p>Iat\u0103 cum po\u021bi elimina duplicatele din Excel f\u0103r\u0103 a \u0219terge datele de care ai nevoie.<\/p>\n<p>Aceea\u0219i aten\u021bie trebuie acordat\u0103 \u0219i software-ului pe care rulezi toate acestea. O copie original\u0103 \u0219i licen\u021biat\u0103 corespunz\u0103tor a pachetului Office \u00eenseamn\u0103 c\u0103 formulele tale, func\u021biile precum UNIQUE \u0219i fi\u0219ierele tale se comport\u0103 exact a\u0219a cum este descris \u00een documenta\u021bie. <\/p>\n<div class=\"pb-cta\" style=\"background: linear-gradient(160deg,#0f1032 0%,#1e1b4b 45%,#3730a3 100%); border-radius: 18px; padding: 40px 32px; margin: 36px 0; text-align: center;\">\n<div style=\"display: inline-block; color: #c7d2fe; font-size: 11px; font-weight: bold; letter-spacing: 0.08em; text-transform: uppercase; padding: 6px 14px; border-radius: 999px; margin: 0 0 16px;\">\ud83d\ude80 Accelereaz\u0103-\u021bi cre\u0219terea<\/div>\n<div style=\"font-size: 26px; line-height: 1.25; font-weight: 800; color: #ffffff; margin: 0 0 10px;\">Rula\u021bi Excel cu o licen\u021b\u0103 Office original\u0103<\/div>\n<div style=\"font-size: 15px; line-height: 1.5; color: #c7d2fe; margin: 0 0 22px; max-width: 640px;\">Ob\u021bine\u021bi instantaneu o cheie autentic\u0103 pentru Microsoft Office, astfel \u00eenc\u00e2t toate func\u021biile s\u0103 func\u021bioneze conform specifica\u021biilor.<\/div>\n<p><a style=\"display: inline-block; background: #4f46e5; color: #ffffff; font-size: 16px; font-weight: bold; text-decoration: none; padding: 15px 32px; border-radius: 999px;\" href=\"https:\/\/keyfy.com\/ro\/\">Ob\u021bine\u021bi chei originale pentru Office \u2192<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Afla\u021bi cum s\u0103 elimina\u021bi datele duplicate din Excel f\u0103r\u0103 a pierde datele valoroase. Marca\u021bi mai \u00eent\u00e2i, verifica\u021bi selec\u021bia coloanelor, apoi \u0219terge\u021bi \u2013 deoarece opera\u021biunea este definitiv\u0103 \u0219i nu afi\u0219eaz\u0103 niciun avertisment. <\/p>\n","protected":false},"author":1483,"featured_media":38584,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_glsr_average":0,"_glsr_ranking":0,"_glsr_reviews":0,"footnotes":""},"categories":[324],"tags":[],"class_list":["post-38583","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-birou"],"acf":[],"_links":{"self":[{"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/posts\/38583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/users\/1483"}],"replies":[{"embeddable":true,"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/comments?post=38583"}],"version-history":[{"count":1,"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/posts\/38583\/revisions"}],"predecessor-version":[{"id":38606,"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/posts\/38583\/revisions\/38606"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/media\/38584"}],"wp:attachment":[{"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/media?parent=38583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/categories?post=38583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/keyfy.com\/ro\/wp-json\/wp\/v2\/tags?post=38583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}