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

[@DeepakEduWorld]

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

[@doctorfatima8028]

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

[@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 🎉

[@sharmaradheshyam625]

Hii

[@ramsevakjhariyajhariya2703]

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

[@nimeshvasava4911]

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

[@anandlondhe1438]

Thank you sir ❤ aapne mera bahut time bachaya 😊

[@sumis1987]

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

[@praveenkumarphandi9761]

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

[@garg628]

Right time I find ur video, it was helful

[@DeepakEduWorld]

Glad to hear that

[@atanuroy3548]

Nice video.Kafi kuch sikhne ko mila.

[@ashasuryawanshi2491]

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

[@junaidshaikh4880]

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

[@rajat.johari29]

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

[@ashwanichaturvedi9639]

Very useful video Thanku Deepa ji.

[@shabnammalik7127]

Thank you so much sir meri bht help ho gyi h

[@irfanshaikh9597]

Dear Deepak you are great.

[@saanvis2315]

Extreme super teaching

[@the_vipul_solanki]

Tq so much
You saved my lot of time

[@rajendrakumarn7452]

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

[@pervezkhn]

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

[@bhavikarohilla4872]

Vry informative tysm

[@kiransati3508]

Bhadiya yrrr

[@manjit.sarania]

Very good information sir

[@maimisweet8173]

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

[@XploreWithRaju]

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

[@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.

[@kuldeep_tyagi]

Keep it up bro 👍

[@sonusaiman1136]

Great work sir 🙏🙏

[@ramrajya963]

Thank u so much aapka bahut dhanyawaad

[@pronotoshnath8821]

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

[@pervezkhn]

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

[@khirodpadhan8085]

Very nice formula I am very happy Deepak sir

[@DeepakEduWorld]

😊😊

[@a2z_entertainmentzz]

Great knowldge bro

[@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

[@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.

[@humeranazi6388]

Greatest sir

[@Singernkteotia]

Control panel ki ek playlist banado guru

[@vijaylaxmisharma6318]

Superb video bhaiya

[@inspireandamantravels]

Thanks sir ji👍

[@rozee427]

Good work 👍

[@ashasuryawanshi2491]

Thanku Sir 😊 🙏 😊 🙏 😊 🙏

[@sajanmokashi5892]

Thanks !! This best valuable video

[@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

[@kanhucharanadas3948]

Supper Deepak sir..really very good

[@ashutoshtiwari9372]

Loved your video...

[@AllRounder-fr9sw]

Bahoot sahi sir, Thank you

[@subramanyaba9297]

Good teaching

[@tusharpatel4286]

Most usefull sir. Thanks

[@alokbansal3511]

Thank you it help me

[@chinnappaiahramaiah7741]

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

[@khanboy75]

th-cam.com/channels/xowxjj0B4FltVuO_vpmS1w.html

[@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

[@suryakumardas167]

Thank you😊😊

[@mumtazahamed807]

MASHAH ALLAH VERY USEFUL SOLUTION

[@preetiKumari-cm2sn]

u give excellent classes sir

[@DeepakEduWorld]

😁

[@myfavoritesong8773]

very very usefull for me dear .....

[@skgayakvad8641]

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

[@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.........

[@apeduworld7004]

Nice video sir

[@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.

[@jbdetroj2054]

Nice to learn!

[@kiransati3508]

Thanks Deepak sir..

[@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

[@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

[@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

[@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

[@adarshbajpaibhaktofbhole2231]

Thank you soo much sir 💟

[@Dakshstudiomadawada]

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

[@chandanarya1784]

Deepak sir
Thanking and wishing you a happy new year-2018
I am a regular viewer of your video in TH-cam
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...

[@ishanrelan]

good video thanks

[@satyasharanmanitripathi728]

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

[@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

[@__--850]

Thank you sir, easy

[@magbulmansuri4636]

very nice information

[@sarojmeher585]

Good..

[@asmrindia]

NICE SIR

[@nature5710]

Very helpful tyx

[@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

[@ravibisht8684]

Super

[@MAQGuide]

Nice dear..

[@ZAHOORAHMAD-nh1us]

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

[@only4technical722]

Nice videos........sir
Thank you

[@sayrasaya9030]

nice very nice

[@waheediqbal6972]

Thanks

[@varunendrasingh777]

Ho gya thanks

[@sakshimahakal7214]

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

[@pawansharma940]

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

[@JitendraKumar-dd1ed]

Good

[@kamalkumar-rh3nk]

THANX BRO.

[@Arif-bt2rb]

Thanks Bro...

[@natwarlalchejara4215]

Greats

[@asmrindia]

Nice

[@RajuDas-cd2rp]

Amazing

[@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.

[@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

[@syedmuneer18]

Sir agar aik line mai / laga howa ho or dono taraf ph no likha ho tu kis tarah nechy wali line mai 2 nd ph no ajye plz share this thing.

[@Nirmalya_kumar]

Tq

[@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

[@Lolztoons]

Thank you

[@onlinehub3339]

Mujhe 2 colum ko comparing krni vo kaose possible h ...plz tell me urgent... required...

[@DeepakEduWorld]

Use if formula.. To compare columns value

[@gujjuji5449]

Love you sir

[@DeepakEduWorld]

😊😊😊