Advanced Filter in excel in Hindi - Advanced Excel Tutorial in Hindi - Auto VS Advanced filter

Подписаться 1,2 млн

Просмотров 302 тыс.

50% 1

advanced filter in excel in Hindi MS EXCEL 2007 2010 2016 & 2013 - ADVANCED FILTER की मदद से Data को Filter करना with 5 Different examples - Filter and Advanced filter में क्या फर्क है auto filter vs advanced filter - how to use filter the list in place and copy to another location features of advanced filter detailed explanation. advanced excel.
The #advancedfilter feature in MS Excel helps the user analyze worksheet data based on multiple criteria using a 'criteria' range. Advanced filter in Excel can also help display only unique values. Filtered data can be displayed in-place or in other rows and columns of the worksheet. #deepakeduworld #excelinhindi
Sort and Filter In Excel in Hindi - How to filter data in excel Hindi Watch This video • Sort & Filter Data In ...
Sort and Filter In Excel in Hindi - sort data in excel by value , cell color or font color in Hindi • Sort and Filter In Exc...
ADVANCED FILTER VIDEOS SERIES:
1. Advanced Filter in excel in Hindi - Auto VS Advanced filter
• Advanced Filter in exc...
2. Filter Data To Another Sheet In Excel | Using Advanced Filter in Hindi
• Filter Data To Another...
3. How To Filter Data For Blank Cells In Excel | Using Advanced Filter In Hindi
• How To Filter Data For...
4. Advanced filter unique records only in hindi
• Advanced Filter In Exc...
5. Make ADVANCED FILTER Dynamic || Auto Updating || Filter To Another Sheet
• How To Make ADVANCED F...
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
We Always Provide Useful & Helpful Content On The Deepak Eduworld RU-vid Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
Tags : advanced filter in excel 2010 in hindi,how to use advanced filter in excel 2007 in hindi,advanced filter in ms excel in hindi,advanced filter ms excel hindi,hindi,excel,advanced filter,advance excel,filter in excel,microsoft excel,excel in urdu,excel in hindi,use filters in excel hindi,advanced,filter,in excel,urdu,auto filter,filter function,internet,deepakeduworld,deepak eduworld,unique record

Опубликовано:

30 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 404

@DeepakEduWorld 5 лет назад

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

@muzaffarraza2435 5 лет назад

Bahut achha apka ye video dekh kr ...total samjh gye

@farhakhan470 6 лет назад

Sir, Filter & advance Filter me kya Different hai...sir y hm only Filter me bi to kr skte hai...plzz Sir ap btay Advance Filter me hi kiyo ?

@anujyaduvanshi7745 8 дней назад

Sorry bro mujhe Kuch samjh nhi aaya

@mamtajaiswal7465 2 года назад

Deepak ji your videos are very nice .but your typing cell is blur ,plz clear this , i don't understand ,what type you on sheet..plz clear showing

@altafhusainansari4282 Год назад

Hi, Deepak Jii. Is trip me ap Uniq name Nikalne ka Nahi bataye hai. Kiya Uniq Name Bina Macro k Nikal Sakta hai.. Mecro k sath mene use Kiya hai Par without Mecro Use nahi Kiya hai. Kiya Without macro Advance Filte k use kar k Uniq Name Nikal Sakte hai kiya...

@MuhammadRamzan-zj8sv 2 года назад

Brother I have a question please help me. This is a daily out gate items to patties sometimes items name are same and models and color are different. But I want sum quantity of items from this table of particular party with same model and color please brother give me some advice. I have a sheet which having 6 main columns as it is Dates, Party name, Item name, model, color and quantity. But I want sum quantity of items from this table of particular party with same model and color that are repeating during a time duration.

@mukundraverkar4009 Год назад

Requesting you for your valuable views which is better office 365 or any other MS office version as on date

@manikpasalkar2190 4 года назад

अगर किसी कौलममे कंमेंट लिखी हो उसी सबके (सिर्फ कंमेंट किये हुए रेकॉर्ड ) रेकॉर्ड कैसे फिल्टर कर सकते हैं?

@kalikali5243 Год назад

Deepak bhai i am not having filter function showing but filter xml is showing please help me

@Akumaryad 5 лет назад

Friend mujhe ek confusion hai. Vlookup and hlookup , filter ya advance filter s kaise alag hain.

@AnirudhKumar-wv2cb 11 месяцев назад

Explanation good but sir I have query data validation ka use karte hue advance filter kaise use kare please make a video on it

@sudiptobiswas1772 3 года назад

dear sir, pls mujhe help kijiye, mera ek question hai, agar mera data bohot bara hai, then mejhe bar bar select karna hoga according criteria, mein kiya us data range ko table mein convert kar sakta hu ?

@ranjana5660 2 года назад

Thank u sir

@dushyantkumarsahu7474 5 лет назад

Hi, Agr advance filter dusri sheet me use karta hu, to obviously particular filtered data source sheet se dusri sheet me copy ho jata h, Agar mai source sheet me bad me update karta hu, to updated data dusri sheet me automatically copy nhi hota, Same process dobara karna padta hai Is there any solution ki bad me update hone wali data bhi automatically copy ho jaye Please comment

@javedahmed8343 9 месяцев назад

You should have mentioned the two or more conditions based on the same column.

@vishanshukumar482 2 года назад

sir is me unique record only Ka MATLAB

@sbrajasthanihd9301 Год назад

It is very different from the CBSC course

@Ansari_Brother786 3 года назад

Sir Please Naming Range Ka video banaye jo ki samhnne mai aasani ho

@amaanahmed1058 5 лет назад

There is no need of putting " " in the cells It works without that also

@legaldiary5401 5 лет назад

No need to put = as well

@Pankajgamer9766 2 года назад

Sir mis report 7 version me video bna dou excel ki

@rashmiranjansamal6590 6 лет назад

mujhe advance filter ke ware me kuche jan na hey .apke mail id dijiye

@ashokmirasi9550 Год назад

Thank you so much ❤️ brother

@Jairohit 4 года назад

Sir ye ram ke sath raman b dikha raha he unique records only karne k baad bhi

@Kakarneha40 2 года назад

Advance filtter ka use acha nhi lga bilkul bhi

@SHORTMOVIES-bc7jy Год назад

I am also a teacher university

@niteeshkumarkushwaha6871 2 года назад

Very good supporting video

@GAMINGPLAZA100 2 года назад

Love you bhaiya 🤗🤗

@NavinKumar-ie5ye 2 года назад

Ghar jadhu kuku 😠😠😠

@VishalKumar-fj7qm 2 года назад

practice file download krni hai

@anjalisiwach8814 2 года назад

Thank you very much sir,,you solved all my problems with ease..😊🥰

@cindrellaprincess8718 4 года назад

Was littler hard topic😥

@garimasachdeva5348 Год назад

Very nice explanation

@jigar7755 2 года назад

Namaste. You have been teaching in easy to understand way. I think advanced filter is much easier to use in comparison to vlookup and index with match. Since both have identical usage.

@ajayram794 3 года назад

Thank you so much sir 😊❤️

@GaganSaraon 11 месяцев назад

Sir aapki ms access ki video nahi mil rahi hai.

@furkanmanzoor7945 2 года назад

Thank you so much sir

@purushottamjha3925 2 года назад

Very Helpful Video.

@KuldeepSingh-nq1vi 4 года назад

Very nice video bro..

@kmanoj392 2 года назад

Very good advance

@NoName-sq2xx 2 года назад

Thank you sir ji.

@wahidrashid4865 5 лет назад

very very nice sir

@vivekvishwad766 2 года назад

Or condition ka nahi sikhaya

@GAMINGPLAZA100 2 года назад

Mene to Puri vdo dekhi

@MANUMANU-wl8vj 3 года назад

Very nice video sir

@poojachouhan496 Год назад

Sir very nice video

@LovepreetKaur-ms9yq 5 лет назад

Kya app hame advance excel ke excellent short cut keys ke bare me bata sakte hai all short keys

@DeepakEduWorld 5 лет назад

G blkill.. I ll publish video as soon as possible

@rakeshchandaliya5196 2 года назад

👍

@dwijendralalbhowal3984 2 года назад

Sir mujhe यह Bata dijiye की Hum IF function का condition fulfill होने की इसकी condition के bare mai agar हमारे values 0show karti है तो kya value condition fulfill नहीं होती अऔर condition false होती है.

@RadhikaSharma-be4rq Год назад

👌👌

@prateekgupta7703 5 лет назад

Sir g alag alag colum m 1 hi value k ek sath record filter hoke Kaise copy honge

@DeepakEduWorld 5 лет назад

Please watch another video on this topic.. Link is given in description of this video

@shantilalrajput8708 4 года назад

Thank you sir

@RoshniKoli-i2h 5 месяцев назад

Very nice video

@iftekharhussain5910 5 лет назад

Very nice video

@shinewithbhumika698 Год назад

Well explained

@basantkumarchandola2897 3 года назад

धन्यवाद।बहुत सुन्दर video है।मैंने भी same table बनाई है।सब कुछ ठीक है ,परन्तु टेबल के अंत में add करने पर drop down list में show नही हो रहा है। कृपया मदद करें।उम्मीद है कि आप रिप्लाई जरूर करेंगे।

@officialimmu9447 2 года назад

Good sir

@vikashr.dwibedi984 Год назад

very nice video

@rahulmakwana7578 6 лет назад

Sir Excel me acending order ho saktahe advance filter ki madad se.

@DeepakEduWorld 6 лет назад

Hmm ho jayega.. But kafi lamba proc3ss hoga.. Its batter to use auto filter

@pafafridi 5 месяцев назад

Hi sir, I have seen your video today. I kindly need a little help on your table, Let's we want a summary to count all data of column F in the same sheet or next summary sheet with name and count automatically , suppose there is a Garments= 04 Electronics = 03 Furniture=02

@MrPZAHOOR 4 года назад

awesome Sir

@rohitdixit0312 5 лет назад

Copy those record they does not live in Delhi city sir ye kaise hoga

@DeepakEduWorld 5 лет назад

Interesting .... I ll make a video on this . As soon as possible

@SHORTMOVIES-bc7jy Год назад

Love you sir

@SubhashKumar-wl5nj 5 лет назад

Apka samjhane ka tarika bohat acha hai Sir superp jo ek bar samjhane par hi mind me beth jata hai.

@pcmodi123 5 лет назад

नमस्कार सर जैसे हमें कोई भी एक सीट है क्या से 5 पन्नों की सीट है उसके अंदर कोई नंबर या बेल नंबर हमें फाइंड करना है तो कैसे करेंगे आपने जो एक ऊपर बताया है एडवांस फिल्टर रूठ कर हम बार-बार तो एडवांस फोल्डर नहीं लगा सकते ना सर ऐसा कुछ बताएं कि कोई भी नंबर कहां से भी ढूंढकर लेकर आगे ओ जानम दिखे तो तुरंत मिल जाए में

@upmasingh5556 11 месяцев назад

Very nice 👍

@SurendraSingh-vi2bs 5 лет назад

Deepak ji meine Excel video de dekhi hai aur muche kuche sawal hai tha

@DeepakEduWorld 5 лет назад

???

@ImranKhan-fc5ei Год назад

Excellent

@bijaytanty8434 11 месяцев назад

Thanks 🙏

@BinodKumar-qq8lu 5 лет назад

Very Nice

@tripathivl 6 лет назад

Very good

@hanumantsinghrana9244 6 лет назад

kya hum apne PC ko internet server bana sakte he only for personal use.

@DeepakEduWorld 6 лет назад

Ys.. Well i will publish a video on this intresting topic shortly

@poojathakur3386 2 года назад

Great

@bikramaggarwal4900 5 лет назад

i have 8 sheets in same workbook. its classwise sheets i. e. I, II, III, IV, V, VI, VII, VIII. in all sheets there is some EWS STUDENTS. How i can club all the EWS students list on one sheet with advance filter

@DeepakEduWorld 5 лет назад

🤔 Good question... I ll try it. How is that possible.. 👍👍👍 I will publish video as soon as possible

@mansooralam626 5 лет назад

Nice traning..!!!. Deepak Ji, aap ko message kaise kren..!?

@therestartsingingsangu7143 2 года назад

Sir I got some difficulty while doing advanced filters on single condition of total sale >2500 after applying advance filter my results is not showing on the table I can see only the headings not the table ... Pls solve my queries

@alpeshlpatelpatel7735 Год назад

Good

@NadirNadeem-v2z 10 месяцев назад

good

@krishnamurthy-jf3kp 4 года назад

Sir very nice video, I have a question can I use multiple criteria in same column? Example: Both A & B should be filtered out of 20 alphabets is it possible

@mamuninayak875 Год назад

Sair samaj nahi aaya

@ChandanKumar-lb7lh 5 лет назад

Sir advance filter se milavat filter kar sakte hai.

@DeepakEduWorld 5 лет назад

🤣🤣🤣🤣

@amratbhaipadhiar9511 5 лет назад

Sir.muje Gujarati LMG arunme likhe kahisare books ke name ko k ka ki Ku....tarah short karna hai to Gujarati tax ko barakhdi mujab kese excel me sort kar sakate hai.pls.do it.my whatsupno 7203000854 hai.

@venkat_1956 5 лет назад

Bahuth accha

@vikashkumar-kb7ki 3 года назад

Samajh nhi aaya hai

@ladlecoachingcentre 4 года назад

Super vedio

@SHORTMOVIES-bc7jy Год назад

Acha phdate ho

@nilimasahu3026 2 года назад

Sir,=">=1200"me formula me result 4cell ki jagah mere 3 cell aa rha h,electronic ,electronic,furniture Ki cell aa rhi h

@thakuryogesh9744 3 года назад

Sir ji namaskar trick was wonderful and intresting.

@engrsaadkhan8626 6 лет назад

it was awesome dear sir love from pakistan

@GAMINGPLAZA100 2 года назад

And sabse accha mujhe iye lagi ki apne itne sare examples diye

@TheAsifansariable 6 лет назад

Hi Deepak... Appreciate your work ...fabulous.... I have one question , I was apply advanced filter and trying to copy to another sheet but every times error shows , is this mean we are bound to copy only on active sheet ?

@ritikasingh6948 2 года назад

Bhot achha

@kaka_sharma 3 года назад

Sir mere laptop pe filter fourmula nahi lagta,

@DeepakEduWorld 3 года назад

Ye abhi keval office 365 me hi hai

@salauddinkhokon5596 4 года назад

Hello Mr dipaak sir, mayne apka bohat tutorial Dekha, or bohat kus Shikha . magar apka jo invoice back up tutorial he usme apne pura invoice ke back up lane ki tecknick nahi dikhaya. Jo bhi Ho hamna hamara apni buddhi sa pura invoice record ki back up Lana MA success hua he . leaking AK Naya samasya khara hua ha, jub hum Naya invoice back up entry lata ha ,Purana entry line sirf ek hi line record show karta ha. is samasya ka samadhan hum kaysa kara sir. koye hall hay Kia, agar up chata ha to hum is problem ki screen short vage na chahta ha.up LA Lia bohat subh kamana ha.

@RAQEEB286 Год назад

brother, In Advance filter, seperate two range & separate two crieria but result two seperate Place in one refresh button, Is it possible? Please Solution soon