How To Easily Find and Delete Duplicate Data Entries In Excel HINDI

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@ruchikasharma6435]

Sir me apko thanx kehna chahti hu sir....jitna apki videos se dekha utna mene computer sir se b ni .... Aaj Mera data entry operator ka interview tha, or sir Mera selection ho gaya.... Sab apki vajah se🙏🙏🌸🌺🌺🌺😊😊thanx alot Sir 🙏😊

[@yogiyadav9497]

🎉🎉

[@Sonuparjapati77]

Very good 🎉

[@doctorfatima8028]

You should make more videos on various softwares because you are one of the greatest online teacher I have ever found

[@sumitsonusoni]

गुड विडियो👏👏👏👏👌 very helpful. इसी तरह जैसे दो रो या तीन रो में एक जैसा डाटा है और इसी तरह का डाटा की लंबी लिस्ट है तो सभी डब्लीकेट डाटा को मर्ज करके यूनिक कैसे बनाएंगे।

[@ramsevakjhariyajhariya2703]

आप महान हो sir ji so moch

[@anandlondhe1438]

Thank you sir ❤ aapne mera bahut time bachaya 😊

[@junaidshaikh4880]

This is the best video I had found today for removing duplicate values in excel. Thanks for it.

[@Rjno1only1]

Sir, you are very Wonderful. I am a MIS Analyst, I learn everyday from your videos.

[@nimeshvasava4911]

Superb ..... thank you sir.....1 hour ka kam 1 second me ho gaya...... thank you very much

[@maimisweet8173]

Very helpful.. Kindly guide that how will we remove duplicate data from rows?

[@praveenkumarphandi9761]

Great sir.... Your method of teaching is very simple & clear. Very easy to understand. Thanks for making sure useful videos for us sir..

[@sriashi7758]

Thanks for this video, sir. kya whole file means 10-12 sheets se duplicate data ko ek baar me find kr other sheet pr peste kr sakte hai.

[@DeepakEduWorld]

+Amit micknight one by one

[@skgayakvad8641]

Sir kya sabhi worksheet me duplicate entry check kar sakte hai kya

[@pervezkhn]

many people have tried different things so with the help of yours i am preparing

[@FarahVision]

Superb video.. I have a request, please ek video me excel me 3 worksheets k elawa 4th sheet add krne ki restriction btayein.. k hamne jo sheet banayi hai us me koi new sheets add na kr sakay. New sheet restricted trick btayein plzzzzz

[@garg628]

Right time I find ur video, it was helful

[@DeepakEduWorld]

Glad to hear that

[@ashasuryawanshi2491]

Mera तो काम हुआ ये video से 🙏🙏🙏

[@ramrajya963]

Thank u so much aapka bahut dhanyawaad

[@ashwanichaturvedi9639]

Very useful video Thanku Deepa ji.

[@it-expert5394]

Sometimes duplicate data is irritated you, sometimes it just makes it difficult to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them.

[@rajendrakumarn7452]

Thank you for posting these easily understandable videos. The way you explain makes it easily comprehensible

[@irfanshaikh9597]

Dear Deepak you are great.

[@atanuroy3548]

Nice video.Kafi kuch sikhne ko mila.

[@btsfact07]

Thank you sir

[@pervezkhn]

all inventory + financial statements combine to put the entry and give u the result of all such as Petty cash, cash book, inventory, journal ,ledger, T.B, B.S, P&L, CASH FLOW, CUSTOMER,supplier ledgers CGSold statement and more if i get any problem i want help form u thanks

[@arjunsingh1811]

Very useful video Thanku Deepa ji meri Ek Problem hai kya aap kisi option se solutions nikal sakte hai pls.confirm

[@DeepakEduWorld]

what solutions...?? please tell me

[@the_vipul_solanki]

Tq so much You saved my lot of time

[@shabnammalik7127]

Thank you so much sir meri bht help ho gyi h

[@Singernkteotia]

Control panel ki ek playlist banado guru

[@mukarramsamdani3625]

Hi deepak ji batayiye excel sheet me ek item code aur name me agar alag alag jaghe par alag value hain to use kaise calculate karte hain plz plz tutorial share kare.

[@saanvis2315]

Extreme super teaching

[@khirodpadhan8085]

Very nice formula I am very happy Deepak sir

[@DeepakEduWorld]

😊😊

[@pervezkhn]

dear deepak i appreciate your work i am a beg follower of u keep it on

[@chinnappaiahramaiah7741]

I would like to say thank you. Your explain on Excell is highly appreciated. It's easily understood.

[@khanboy75]

kzbin.info/door/xowxjj0B4FltVuO_vpmS1w

[@gorakhanathk5054]

While removing the duplicate entry for a required column, for e.g. phone number, the command removes second and further all complete entries/records by retaining the first one. Sir, is there any option that will first tell us which entry is to be removed and option will be given to the user for removal?

[@DeepakEduWorld]

Vba is only solution

[@ashwanikumarchaurasia1593]

data validation me duplicate entry aur countif formula dono ek saath kaise lagaye e.g. aadhar card ke liye 12 digit aur duplicate aadhar entry rokna hai.

[@chandanarya1784]

Deepak sir Thanking and wishing you a happy new year-2018 I am a regular viewer of your video in KZbin I have tried many time to save "spellNubmer" formula in folder, followed by you in video,but after using it once the formula dose not work in another bill how to save it permanently to frequently to use

[@DeepakEduWorld]

+CHANDAN ARYA VERY HAPPY NEW YEAR TO U ALSO... dont wry.. i'll publish a new video very soon...

[@jitusahusadwalkboy6290]

Deepak bhai mujhe ekk help chaiya. 1sheet main wrong, excess and short kesa show hoga with against invoice in excel mujhe uska formula and function batao pleae

[@XploreWithRaju]

Aj apke liye mera kam ashan ho paya.. Isiliye comment box tak chale aye

[@pronotoshnath8821]

Thanks a lot for make me to understand. Thank you sir.

[@satyasharanmanitripathi728]

Sir... multiple sheet me hum kaise find karenge duplicates ko... Request hai ki ek video banayein..

[@manjit.sarania]

Very good information sir

[@muhammadimranbukhari938]

I have A column values and B columns values comparison, in C column I want the missing values in it for example A1 cell contains abc, def, ghi and B1 contains abc, def so if I compare both cells, missing string "ghi" will be shown in C1

[@a2z_entertainmentzz]

Great knowldge bro

[@varunjain7976]

Thanks for this video.

[@prabhattiwari3669]

Thanks 😊

[@inspireandamantravels]

Thanks sir ji👍

[@humeranazi6388]

Greatest sir

[@sonusaiman1136]

Great work sir 🙏🙏

[@ZAHOORAHMAD-nh1us]

I have some data in different column I want to apply to duplicate one separate column how I do one time

[@subramanyaba9297]

Good teaching

[@bhavikarohilla4872]

Vry informative tysm

[@kiransati3508]

Bhadiya yrrr

[@ashutoshtiwari9372]

Loved your video...

[@vijaylaxmisharma6318]

Superb video bhaiya

[@alokbansal3511]

Thank you it help me

[@mrCetus]

u give excellent classes sir

[@chavadanagji7366]

Plz ek help kar dijiye frd Agar apke pas ek sheet me se bahot sari sheet me data ek sath transfer ho jaye esa koe formulla ho to plz video post karna

[@sakshimahakal7214]

Sir tally prime ka master data ko tally erp 9 mein kaise convert kar sakte hai? Pls guide me

[@reshmasharma7200]

Dear sir, Mujhe 1 help chahiye thi.hum 19 Excel works book me customer wise kuch data feed kiye hai har sheet me product name mention hai n uska total quantity n value v nikala hua hai bt ab mujhe 1 Excel sheet banana hai jisme sirf product name, quantity and value rahega..yea Mai kaise easily karu. Plz help kijiye as soon as possible.. urgent hai Thora sir.

[@sajanmokashi5892]

Thanks !! This best valuable video

[@akhileshsharma1644]

Sir excel sheet mai kuch data hai us data ka 65% to 85% data mujhe next sheet mai lena ho to kaise kare. Sheet 1 se data automatic 65 to 85 % le sheet 2 mai randamely

[@Nirmalya_kumar]

Tq

[@ashasuryawanshi2491]

Thanku Sir 😊 🙏 😊 🙏 😊 🙏

[@tusharpatel4286]

Most usefull sir. Thanks

[@kiransati3508]

Thanks Deepak sir..

[@waheediqbal6972]

Thanks

[@pawansharma940]

Sir, Excell sheet m date ko kaise filter lga kr short kiya jata ha? Pls btaye

[@manojitmukherjee1142]

Exm--- Party Name, Lot No.,Product,, Sub Product, Qt.,Rate, Amount///////// Manufacturing Process......Raw Purchase..//Process-1/Process-2//Process-3//and Finish Product Dada Pls, how to Stock Maintain through Excel......Full Video Pls Dada upload kijiya, jitna jaldi ho sake..... thank you...

[@AllRounder-fr9sw]

Bahoot sahi sir, Thank you

[@krmotionexcel]

deepak bhai.... can you solve my query please. ********************************* "mere pass 8 digit ke 500 se jyada numbers he........or muje numbers ko particular group wise cell color kerna he to kese karu....... muje sirf 1st 2 digit ko track karke ..... cell highlight karna he....... please help me .....!!!!!!!!!!!😢😢😢😢 mere pass product ki packing list he.....usme product ke different different code he......., to use 1st 2 digit ko ko track kar ke kiya ja sakata he highlight.........

[@varunendrasingh777]

Ho gya thanks

[@kuldeep_tyagi]

Keep it up bro 👍

[@Dakshstudio]

Sir duplicate entry ko ek sath jod ke total kese kare keval single row me

[@ABHISHEK-237]

By use conditional formatting + filter

[@monusharma8625]

@@ABHISHEK-237 kaise krenge sir

[@ABHISHEK-237]

@@monusharma8625 pehle by use of conditional formatting se duplicate cells ko highlight karwa lo then duplicate values par filter ki help se color filter laga do and phir sum kr lo ho jaayega

[@monusharma8625]

Sir mei kr chuki hai lkin isme multipule time aur alg alg values ki duplicate value hai

[@monusharma8625]

Mere pass ek file hai aap bta skte ho usme kaise krenge

[@rozee427]

Good work 👍

[@apeduworld7004]

Nice video sir

[@ishanrelan]

good video thanks

[@myfavoritesong8773]

very very usefull for me dear .....

[@sarojmeher585]

Good..

[@Lolztoons]

Thank you

[@excellentcomputerbilaspur9459]

sir kya kuch aisa ho sakta hai ki duplicate show hi tab ho jab sab mei same ho

[@adarshbajpaibhaktofbhole2231]

Thank you soo much sir 💟

[@zeeshanahmedsheikh2995]

Hello! Bhai may ab tk senkaroo (100) vdos search kr chuka mjhy khy ye nhi mila.... Library may books ki unique ID hoti hay or ye hi ID book ko issue or return krny may kam ati hay... mujhy ye maloom krna hy kay ek book may nay ksi user ko issue ki (user ki bhi unique ID hoti hy). Vlookup ko istemal krty hoy bry achy say kam kr rha hy.. mgr .... masla ye hy hy blky may ye chta ho k jab tk ek book ki ID issue hoi wo hy yani library say bahir gi hoi hay... dobara ksi or ko issue na ho jb tk ka wo wapis na aa jay... is maqsad ka ly may nay vlookup or condition ko hi use krty ho ye bhi dya howa hy k jesay he book issue ki ski row may check out likha aa jata hy or jesay he book return hoti hay or return date enter ki jati hay to wo status colomn may return show krdeta hy... mgar may ye cha rha ho k us sheet may wo 10 times issue ho kr return ho chuki.. leken jab 11 bar wo issue ho to jab tk wo return nhi hoti tb tk 12th time wo issue na ho balkay msage aa jay k its already issued.. hope you will solve my issue and make a vdo on this too.

[@prashant00744]

Sar Aisa ho sakta hai kya Samjho Ek customer hai uske Aage Humne entry di hai to firse uske age entry kare to wo error ajay nahi to highlight hojaye Aisa Kuchh formula hai kya🙏

[@DineshSingh-vw7zo]

Very nice sir

[@ravibisht8684]

Super

[@sumitawasthi6924]

Sir dusari ek sheet ke data ko dusari sheet me kaise dekhe

[@basharatameen3151]

Sir main chahta hn ky jo alag alag duplicate values hn wo alag alag colors my show hn jesy A 3 bar hy wo teno aik color my show hn or B agar jitni bar hn wo alag color my show hn but A ky color my nahi kisi dosry color my plz help in this regard Thanks

[@mumtazahamed807]

MASHAH ALLAH VERY USEFUL SOLUTION

[@santoshchouhan6237]

Sir data entry kaise karte hai btao ..

[@seoamanpandey9153]

Brother agar koi file ho.. mai travel agent email I'd aur name address ho. usko ek row ek bar kaise copy paise kre

[@zaibkhan6834]

Sir I have one problem ke hum kse middle first or last value letey Han agr ek cell me bhtt sarey name Hon jse. Honda Atlas Cars Pakistan Limited ye ek cell me likha Hai to muje ye sarey name alg krne Han separate cell me plzzzz kindly solve it

[@JitendraKumar-dd1ed]

Good

[@asmrindia]

NICE SIR

[@ogowater]

i want delete duplicate mobile numbers but i want only keep new date numbers and previous date numbers delete . i want only recent date mobile numbers. how to do it

[@Arif-bt2rb]

Thanks Bro...

[@khalidshahzad93]

When we delete rows or column in excel formula not work how can resolve this problem

[@jbdetroj2054]

Nice to learn!

[@aishaintezar]

Mere column me dublications jo ati ha usay remove krti hu to uske sath uska row b delete krna hoga to wo kese krugi me

[@rajeshshah7926]

Ye Formula use karke bhi batao pls