5 Best ways to Remove Duplicate Entries in Excel | Excel User Should Know

  Рет қаралды 119,402

mybigguide

mybigguide

Күн бұрын

Пікірлер: 108
@MyLiveSupport
@MyLiveSupport 4 жыл бұрын
सर मैं आपका बहुत आभारी हूं जो आपने मुझे इस काबिल समझा कि मैं mybigguide पर लोगों को कुछ सिखा सकूं आपका दिल से शुक्रिया 😃🥰❤️
@mewaramtoliya53
@mewaramtoliya53 4 жыл бұрын
Corlation two excel master like to banta hai
@mybigguidehindi
@mybigguidehindi 4 жыл бұрын
तो दोस्‍तो कैसा लगा आपको ये वीडीयेा जरूर बतायें 🙏
@nagmasharma8588
@nagmasharma8588 4 жыл бұрын
Sir bahut acha lga aapka yeh video
@monusingh3339
@monusingh3339 3 жыл бұрын
Wah janaab Apne to jaadu he kar diya Mare pass 1 lakh ka data tha jisne Mare bhut c phone NBR dublicates tha but apki video ki wajah se mare sare pareshani door ho gye 😍😍😍
@reenajha2003
@reenajha2003 Жыл бұрын
Thank u so much bro.. U have made my work easy.. I have asked about the same formula to my manager but hse denied saying there is no formula. Like this so I search u tube video and watch ur formula. I have used first formula and it worked. Thanks a lot bro.. You made my day
@VarshaBiswas
@VarshaBiswas 2 жыл бұрын
Thank you soooooo much sir... Apki video ki wjh se 2 min me mera kam ho gya.
@rekhakori9739
@rekhakori9739 2 жыл бұрын
Thanku so much aisi information Dene k liye
@govtofficer.jaspreetkaur9409
@govtofficer.jaspreetkaur9409 4 жыл бұрын
No one can take place of ur channel hats off
@SPG_YES
@SPG_YES 4 жыл бұрын
help me bro
@abhijeetdhole619
@abhijeetdhole619 2 жыл бұрын
Bhai dil se THANKS !
@amyaditi3641
@amyaditi3641 2 жыл бұрын
Very very very helpful. I was using only remove duplicates and countif for searching duplicates but thanks for showing us too many useful options
@pradeepkumarkanhar3128
@pradeepkumarkanhar3128 2 жыл бұрын
Very helpful videos Thanks Sir for good information
@nayazahmedahmed6323
@nayazahmedahmed6323 Жыл бұрын
Excellent Sir, thanks 👍
@SandeepKumar-ze1xr
@SandeepKumar-ze1xr 2 жыл бұрын
Thnx bhai
@Ckthakorfx
@Ckthakorfx 4 жыл бұрын
Happy Holi ❤️❤️ All ( MyBigGuide ) Family 👈
@tallypointaccountingclasse7456
@tallypointaccountingclasse7456 4 жыл бұрын
Thanks Chandan sir and Abhimanyu sir .
@mamtayadav8732
@mamtayadav8732 3 жыл бұрын
I love Ur concept
@harsinchh4342
@harsinchh4342 2 жыл бұрын
Thanks You Sir.🙏🙏
@rajeevgosavi4514
@rajeevgosavi4514 2 жыл бұрын
Very informative . Thanks. Could you also upload the detailed video on complete Power Query please.
@sksaidullah17
@sksaidullah17 4 жыл бұрын
Sir busy Accounting software pa long video banaiyea na sir pure KZbin pa koi abhi acha video nahi hai Ap bahoot acha samghate hai
@lakshmikumar4596
@lakshmikumar4596 4 жыл бұрын
thanks sir
@nirmalyadav9408
@nirmalyadav9408 4 жыл бұрын
best & osm...
@MyLiveSupport
@MyLiveSupport 4 жыл бұрын
Thanks
@SPG_YES
@SPG_YES 4 жыл бұрын
help me bro
@kiransati3508
@kiransati3508 4 жыл бұрын
Thanks sir .
@harshitmaheshwari2127
@harshitmaheshwari2127 4 жыл бұрын
Thanks in advance
@stutisrivastava8582
@stutisrivastava8582 3 жыл бұрын
Thank you
@jkyadav4826
@jkyadav4826 4 жыл бұрын
Very nice sir 💓 💓💓💓💞❣️♥️❤️💛💚 💙💜💝
@ramakantkhade2339
@ramakantkhade2339 2 жыл бұрын
Hi sir, High data me Duplicate data example ka solution karke video dikavo please
@amratbhaipadhiar9511
@amratbhaipadhiar9511 3 жыл бұрын
Very good lesson .sir
@veerukapoorveeru
@veerukapoorveeru 4 жыл бұрын
Very useful and time saving sir.. nice. Sir my one question..??? Ek Excel sheets me 5 to 10 sheet hai...or unmey se ..one sheet me 20 to 30 party ki entry hai.. different name or detail ke Saath.kya yesa ho Sakta hai ki alag 2 name ,date or detail alag 2 sheet pe transfer ho Jaye... Matlub..sheet on me entery ho or data transfer ho Jaye.. Fir example Date .xxxx Name ..ram Good of purchase... Amount. One sheet me ram ki entry Kare to ram ke ledger me transfer ho Jaye details.or shaym ki entery Kare to shayam ke Ledger me transfer ho Jaye. Sir ,pls reply
@dilwalahindustani6837
@dilwalahindustani6837 4 жыл бұрын
sir big data k liye konsa method sahi rahega plz btaye
@COMMERCEKAKEEDABYEDUNATION
@COMMERCEKAKEEDABYEDUNATION 4 жыл бұрын
Nice
@ajayakumar9755
@ajayakumar9755 4 жыл бұрын
Mny mny thanks sir
@sunyapuran2283
@sunyapuran2283 4 жыл бұрын
Hello sir kyaa ham koi vi xls file ko web site me rakh kar use usi web site se dekh sakte hai?
@sarvodayaconventvidisha1757
@sarvodayaconventvidisha1757 4 жыл бұрын
वाह
@SPG_YES
@SPG_YES 4 жыл бұрын
help me
@dewabhai6578
@dewabhai6578 3 жыл бұрын
Sir mere ko aap se ek questions puchhna hy questions ye hy ki data jaise example-use in excel 5 count 4 5 0 5 0 5 0 2 count. 5 2 0 2 0 2 0 2 0 Aisi bahut sara data ho to usme kis formula ka use kare ki sare data aisa so kare jaise uper dala hu sir pls help..
@shubhamchapekar3436
@shubhamchapekar3436 4 жыл бұрын
P value kaise nikale is par video banaiye sir please
@dildarali5873
@dildarali5873 4 жыл бұрын
Hello sir, master documents k bare me aik video banaen. Thanks
@ghanshyambhandari015
@ghanshyambhandari015 4 жыл бұрын
thank sir next video आप नेपाल लिय usable भिहुनेवालि video बनाय sir Nepal me bhai aap ka video dekhate he me Nepal se hu sir.
@anuublis5717
@anuublis5717 Жыл бұрын
Sir Just want to find same name in same row in excel , when having a number of rows in a sheet Any formula that can be used.
@amratbhaipadhiar9511
@amratbhaipadhiar9511 2 жыл бұрын
Gujarati data ko Gujarati baraxari mujab data kase sort kare ?
@UmeshSharma_18
@UmeshSharma_18 Жыл бұрын
Sir koi esi trick h duplicate ya esi value find krne ki exp ek company h xyz Pvt Ltd aur same data m same company ka naam xyz private limited likha h toh isko find kese kare
@itboys6369
@itboys6369 3 жыл бұрын
excel me first row me 5 column ki value second row ki 5 column jesi ho to hi error aaye agar 4 value same ho to error na aaye aaisa kaise banaye plz help me fast
@zeeshanahmedsheikh2995
@zeeshanahmedsheikh2995 2 жыл бұрын
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.
@syedzameerattari4963
@syedzameerattari4963 Жыл бұрын
Sir uska amount kaha PE yad huva batayiye
@pubgwithakshay45
@pubgwithakshay45 4 жыл бұрын
sir excel me office work kaise karte hain ye btaye
@SPHULLBHATI
@SPHULLBHATI 4 жыл бұрын
sir, अगर कॉलम A मे duplicate नाम ह ,लेकिन कॉलम B में डाटा different h जैसे कि sale amount and other column में भी different h, तो हम unique name को मेल मर्ज केसे करेंगे ताकी एक व्यक्ति एक लेटर
@AkashSingh-qe5yu
@AkashSingh-qe5yu 4 жыл бұрын
Sir kya aap is course ko me upload Kar denge please sir bahut children aase he Jo itne paise afford Nahi kr sakte
@sammzm7451
@sammzm7451 Жыл бұрын
How to remove hiperlin k agane and agen
@navinkumar4208
@navinkumar4208 Жыл бұрын
How to remove duplicate word in particular cell in excel
@unreadpages6798
@unreadpages6798 Жыл бұрын
Excel sheets shows dublicate values but there is none. When i copy shown dublicate cell and find it in the same row i get only one value the one i copied..there is no dublicate but it still shows..what to do
@JaishreeRam0Jaihanuman
@JaishreeRam0Jaihanuman 2 жыл бұрын
How to find duplicate entry with 2 different format like 1 file john, Smith and other file we received Smith, john. H
@tallypointaccountingclasse7456
@tallypointaccountingclasse7456 4 жыл бұрын
I want ask a question how to check excel version ( muje kese malum padega ki samne wale ne video ki version par banaya he ) ?
@karimkakal6783
@karimkakal6783 4 жыл бұрын
Dear Sir power point me English language ko Hindi language ke se kare Me Google translate se karta hu Ause bohat dikat hoti hai koi aasan tari ka batai ye si jo puri ppt convert ho jay . Ae kam meri job hai. Muje pata hai ke aap jarur javab de ge. Apka priear subscriber Karim Kakal.
@sudeshsrivastava1435
@sudeshsrivastava1435 3 жыл бұрын
In case of very huge data, where it is not possible to keep that in single excel sheet, in that case we have to create multiple sheets in single excel workbook.. Now without consolidating them, is it possible to remove duplicates among all the sheets by an vba code.
@gubluuk7539
@gubluuk7539 4 жыл бұрын
Power query office 2016 hai na ?
@MyLiveSupport
@MyLiveSupport 4 жыл бұрын
You can also use in this 2016
@naeemsiddiq523
@naeemsiddiq523 3 жыл бұрын
could you please tell me how to do same thing in MS Word? please
@javedshaikh7902
@javedshaikh7902 2 жыл бұрын
Multiple sheets me duplicate kaise find kare
@prajapatisahab9505
@prajapatisahab9505 4 жыл бұрын
Sir mere pas tally ke video nahi aa rahe h please sir btaiye
@sunnydhaania2448
@sunnydhaania2448 2 жыл бұрын
Sir exel me date of birth ko sort kaise kre
@zabivines5908
@zabivines5908 4 жыл бұрын
Sir ms word aor ms Excel 2019 kaha se download kare.... 🙏🏻🙏🏻🙏🏻🙏🏻
@SPG_YES
@SPG_YES 4 жыл бұрын
help me bro
@acieducation6401
@acieducation6401 4 жыл бұрын
Sir ji, Ek bar apne ek video apload kiya tha jisme kuch word likh ker uski file search ki ja sakti thi Wo trick bhul gye aur hume file search karne me problem hoti hai sir ji Wo video ki link fir se de dijiye 👏👏
@ashishkumarpal9795
@ashishkumarpal9795 4 жыл бұрын
Dear ap windows +e kar ke kishi bhi file ya data ko khoj sakte hai
@acieducation6401
@acieducation6401 4 жыл бұрын
@@ashishkumarpal9795 Dear usse kewal direct file name se serch ki ja sakti hai
@mr.v1191
@mr.v1191 4 жыл бұрын
@@acieducation6401 bhai search karke option ata hai file content uspe clik kar dena search ho jaega
@SPG_YES
@SPG_YES 4 жыл бұрын
@@ashishkumarpal9795 help me bro
@ashishkumarpal9795
@ashishkumarpal9795 4 жыл бұрын
@@SPG_YES mai kya help kar sakta hu dear bataye mai puri koshish karuga
@thakurnitinsingh2467
@thakurnitinsingh2467 4 жыл бұрын
Need your help to solve one Excel problem...are you available?
@DataLearninghub
@DataLearninghub 4 жыл бұрын
You can share your query... We will try to give resolution earliest..
@baljinderrandhawa8147
@baljinderrandhawa8147 4 жыл бұрын
Sir ik badi excel video main pura sikh sakte .,to hame chhoti video dekhne ki jarut to nahi pati main confuse hu ke konsi video dekhni chaheyen
@Ahru777
@Ahru777 3 жыл бұрын
sir it does not work on my system kindly convert my list if u r willing then i will cnd u plzzz reply sir
@ramakantkhade2339
@ramakantkhade2339 2 жыл бұрын
hi , sir help me Duplicate data find Rows me data number of stone 70000 he duplicate content finder karne ke baad keep Duplicate option show nahi ho Raha he
@prppatel2116
@prppatel2116 3 жыл бұрын
Are bhai.. at the time hi duplicates entry ka pataa chal jaye vo systems batao na. Ye to GADHDHA majuri karne ke bad chalega... pahle hi pataa lag jana chahiye..
@onkarkumar7533
@onkarkumar7533 4 жыл бұрын
Sir, zooming mahi kiya huwa hai, to dikkat hota hai visible mein.
@khetramPatel
@khetramPatel 2 жыл бұрын
Duplicate value ko change karna delete nahin change karna hai kaise karenge
@Cartoonsbabu
@Cartoonsbabu 3 жыл бұрын
Pivot table m duplicate data Add ho raha hai, I things remove nahi hui hai!
@AshishGupta-kz1jh
@AshishGupta-kz1jh 4 жыл бұрын
Sir , Excel में formula aur function में क्या अंतर है
@DataLearninghub
@DataLearninghub 4 жыл бұрын
Functions jo inbuit hote hai jaise sum, if vlookup etc lekin formula jo hum bnate hai... Like =500/5 or =A1+ B1
@industrymart
@industrymart 3 жыл бұрын
Hello sir. Mere pass. 10000 email ki 10 list He to total. 1 lac email ho gaya. 10 list me muje duplicate email remove karna he to jara batado kese dublicat email remove kare
@govindparihar7635
@govindparihar7635 4 жыл бұрын
Sir mujhe ye pta karna he ki mere paas 100 company ke mal aata he 5 company ke mal nhi aaya mere pass kaise pta kare Excel me
@gouravchugh7524
@gouravchugh7524 4 жыл бұрын
Hello Sir, मेरे पास 4000 नाम वाली excel list है जिसमें मुझे 3 बार या 3 बार से कम repeat same name remove करने है और 3 बार से ज्यादा repeat हुए same नाम रखने है इसका कोई formula या कोई trick बताए 🙏
@DataLearninghub
@DataLearninghub 4 жыл бұрын
Yes iski trick hai...
@arabianoud3812
@arabianoud3812 2 жыл бұрын
Some thing strange for me! I am not getting remove duplicate option in Power Query
@Akuma_art-y5t
@Akuma_art-y5t 3 жыл бұрын
Hi , how to find matches & remove duplicate in two sheet. Ex- 1.Calpol 650 mg in 1st sheet 2.Calpol 650 mg tablet in 2nd sheet. Both medicine is same but entries has wrong .pls.suggest
@roshanpatro2996
@roshanpatro2996 2 жыл бұрын
Hi i am looking for same issue did u find any soln
@hunger6147
@hunger6147 Жыл бұрын
If each cell m hi duplicate text h Ex. My name is, My name is To kaise remove karenge
@shubhamchapekar3436
@shubhamchapekar3436 4 жыл бұрын
Statistics or video banao sir ni
@rajendramehra4651
@rajendramehra4651 4 жыл бұрын
Sir samaj Mai ni aaya mybig giude mai aapka video...
@pritam535
@pritam535 3 жыл бұрын
agar duplicate ko find krke dusri jagah paste krna ho to? delete ni krna duplicate ko
@sachinkaushik9624
@sachinkaushik9624 4 жыл бұрын
सर , मेरेको ms excel में vlookup formula pनहीं आता ! बहुत ज्यादा videos देख ली , पर समझ में नहीं आती !!!😢😢😢😢😢😢😢 Please help me sir,. Mera interview h company me , usme ye jarur puchenge , please help me sir Mereko company me data entry ki job ke liye , interview dena hai. I think usme vloo
@mr.v1191
@mr.v1191 4 жыл бұрын
Sir no offence but apke samjhane ke tarike se door door tak nahi milta inka tarika .... Inhone to uljha diya or ap aise samjhate hai ek he baar me samajh ata hai
@SPG_YES
@SPG_YES 4 жыл бұрын
please help
@Ckthakorfx
@Ckthakorfx 4 жыл бұрын
1st
@SPG_YES
@SPG_YES 4 жыл бұрын
help me bro
@Niteshkumar-ke6cg
@Niteshkumar-ke6cg 2 жыл бұрын
Sir num send kreyo apna
@amar4you367
@amar4you367 4 жыл бұрын
SARCH
@phalgunipatwa9152
@phalgunipatwa9152 3 жыл бұрын
Thankyou so much
@SPG_YES
@SPG_YES 4 жыл бұрын
please help
@MrCagenicholas
@MrCagenicholas 2 жыл бұрын
Thank you so much
99.9% IMPOSSIBLE
00:24
STORROR
Рет қаралды 31 МЛН
What Xlookup Can Do For You ? Xlookup Tutorial - Xlookup in Excel in Hindi
29:23
11 Zabardast Excel Tricks 🤯🔥
22:31
Desi Goodly
Рет қаралды 78 М.