Simple But Powerful Array Formula in Excel 👉 Guidelines and examples in Hindi

Поделиться
HTML-код
  • Опубликовано: 2 янв 2025

Комментарии • 154

  • @mybigguidehindi
    @mybigguidehindi  6 лет назад +43

    तो कैसा लगा आपको ये वीडीयो 😀

  • @dikshitapk
    @dikshitapk 6 лет назад

    Mny mny thnx. Sir.....bht kuch learning kar rahi hoon aap ki video se...

  • @jayantiverma4116
    @jayantiverma4116 6 лет назад

    Thanks sir..ap ke video se bhut kuch sekhane ko milta hai.

  • @shalugarg8072
    @shalugarg8072 6 лет назад

    Sir..aapka trika bhut effective h..

  • @mohammadhashim9963
    @mohammadhashim9963 5 лет назад

    बहुत अच्छा लगा

  • @mukeshkumarsharma8447
    @mukeshkumarsharma8447 6 лет назад +1

    श्रीमान ये तो गजब का फॉर्मूला है ।

  • @007waz1272
    @007waz1272 6 лет назад

    Bahut badhiya,,😙👏👏👏

  • @vakeelsaifi568
    @vakeelsaifi568 5 лет назад

    Bahot bahot achaa video h

  • @SinghDavinder007
    @SinghDavinder007 6 лет назад

    Very nice sir....

  • @rahulmehra375
    @rahulmehra375 6 лет назад +1

    Sir bahut badiya sikhate ho, ek video sir attendance ki banao ki 200 logo ek common attendance sheet unko share kar di Jaye but wo apna employee code fill karke apni absent/present/leave ka status dekh le baki dusre employees ka data hide hi rahe. it is required unki salary process hone se pehle so that unke response liye ja sake. Sir mujhe bahut jarurat hai aise shortcut ki 150 logo ki attendance maintain karni padti hai mujhe.

    • @mybigguidehindi
      @mybigguidehindi  6 лет назад

      क्‍या आपने वह शीट तैयार की है तो क्‍या आप हमें Help@mybigguide.com पर भेज सकते हैं

  • @bikashadhikari5005
    @bikashadhikari5005 6 лет назад

    Namaste sir khub video banaye aapne!

  • @DhiruJi02
    @DhiruJi02 6 лет назад

    Very useful formula dear sir

  • @indrakumarpatelpatel521
    @indrakumarpatelpatel521 6 лет назад

    super sir ji
    mere kam ko aasan kar diya he
    thanks sir ji

  • @aniketshivgan600
    @aniketshivgan600 6 лет назад +2

    Nice Sir ji . Very useful information

  • @sugandhaasolia829
    @sugandhaasolia829 6 лет назад +3

    Ye formula bhut kaam ka h
    Thank you sir

  • @umakantray3988
    @umakantray3988 6 лет назад

    I like your method very easy ...thanks

  • @ankitasharma6392
    @ankitasharma6392 5 лет назад

    Always best sir ji

  • @nileshbagrawala5473
    @nileshbagrawala5473 5 лет назад

    Very helful..

  • @Shyam1472
    @Shyam1472 6 лет назад

    Very nice video

  • @jaihind5935
    @jaihind5935 6 лет назад +3

    बड़े काम की ट्रिक,धन्यवाद👍

  • @ishfaqahmad5894
    @ishfaqahmad5894 6 лет назад

    Thank you sir meny apsi buhot kuch seka hi

  • @harshalsonawane7802
    @harshalsonawane7802 6 лет назад

    Excellent

  • @rajeshkumargaur8019
    @rajeshkumargaur8019 6 лет назад +1

    Very good sir.... very useful formula..thanks...

  • @opgamer3d932
    @opgamer3d932 6 лет назад +2

    Kisi aise aasan course ke baare me bhi batayein jis ko seekhkar koi garib berojgaar apna jivanyapan kar sake aap ki kripa hogi

  • @stepbystepmaths2159
    @stepbystepmaths2159 6 лет назад +2

    it's great formula.... thank you sir

  • @Mercyloveforall
    @Mercyloveforall 6 лет назад

    Very nice and very very informative thanx a billion sir.

  • @arijeetkumarsharma226
    @arijeetkumarsharma226 5 лет назад

    Superb

  • @nirmalpatra2106
    @nirmalpatra2106 6 лет назад

    Super sir

  • @glitterworldcreation
    @glitterworldcreation 6 лет назад +2

    THAT'S GREAT
    HAPPY TO LEARN THAT

  • @murtuz4u
    @murtuz4u 6 лет назад +1

    Very useful information 👍🏻

  • @arvind_singh_vlog
    @arvind_singh_vlog 6 лет назад

    Gajab

  • @rakeshmeshram6282
    @rakeshmeshram6282 6 лет назад

    Nce sir ...

  • @jaipalrana.
    @jaipalrana. 6 лет назад

    Superb!!! extra knowledge!!!!

  • @bikashadhikari5005
    @bikashadhikari5005 6 лет назад

    Biggest guide

  • @azizniazi2454
    @azizniazi2454 6 лет назад

    Really informative

  • @kamaljeetkaursabhi.virende7252
    @kamaljeetkaursabhi.virende7252 6 лет назад +1

    Good sir

  • @pankajchanwala4522
    @pankajchanwala4522 6 лет назад +1

    very good

  • @Ajay24555
    @Ajay24555 6 лет назад

    Very useful

  • @TrueExplorerAnurag
    @TrueExplorerAnurag 6 лет назад

    Sum product bhi use kr skte Hain iske liye

  • @anjaneyulukodam9961
    @anjaneyulukodam9961 6 лет назад

    Good morning sir,

  • @pushpapatel198
    @pushpapatel198 6 лет назад

    very useful for me

  • @chetansharma127
    @chetansharma127 6 лет назад +1

    nice information sir thanks

  • @dharmsinghyadav7090
    @dharmsinghyadav7090 6 лет назад +1

    Very powerful sir

  • @SkYadav-th7hn
    @SkYadav-th7hn 6 лет назад +1

    Very helpful formula

  • @Silver-Clouds
    @Silver-Clouds 6 лет назад

    very helpful you explain it very simple way... I am happy I learn a new formula

  • @puneetvij8433
    @puneetvij8433 6 лет назад +2

    Abhimanyu Sir,
    Carry on. ; )

  • @RAJEEVTOMER31
    @RAJEEVTOMER31 5 лет назад

    Thank you

  • @sajabul244
    @sajabul244 6 лет назад +1

    सजाबुल अली
    !
    !
    !
    Very good and thankyu Sir
    सर Please , Searchable Dropdown List पर एक आसान वीडियो बनाइये!

  • @bharti2845
    @bharti2845 6 лет назад

    sir jee good evening mai apka subscriber hoon meri ek problem hai ki mujhe ek hi cell me multily , substract aur sum karna hota hai jise alag se calculator se karna parta hai usme total karne k baad dusre cell me say amount likhna parta hai kya excel me koi aisa formula hai jiss se mera ye work easy ho jaaye aur time kam lage

  • @pushpapatel198
    @pushpapatel198 6 лет назад

    👍👌

  • @rockysandilya8975
    @rockysandilya8975 6 лет назад

    Sir ifand isblank pe video banaiye na

  • @vasantkumarkantilal2973
    @vasantkumarkantilal2973 6 лет назад +1

    Best video

  • @योगेशपाल-ध7भ
    @योगेशपाल-ध7भ 6 лет назад

    Lvvvv u, sir

  • @glitterworldcreation
    @glitterworldcreation 6 лет назад +2

    Hope you will show some tricks in ms access
    As I have to do lots of work in ms access these tricks can really help

  • @RahulJauhari
    @RahulJauhari 6 лет назад +1

    Very useful video thanks sir

  • @farhanali-lx1md
    @farhanali-lx1md 6 лет назад +1

    I like your viedo

  • @सपनोंकीउड़ान-ध5ध

    Online work ke bare m bhi koi video upload karo sir please

  • @raviyadav-sg9kb
    @raviyadav-sg9kb 6 лет назад +1

    sir g data entry ke bare me kuch naya bnao

    • @mybigguidehindi
      @mybigguidehindi  6 лет назад

      आप ये वीडीयो देखें - ruclips.net/video/9y2JaUzNRdQ/видео.html

  • @user-hf4se9xy1m
    @user-hf4se9xy1m 6 лет назад +1

    Super

  • @hirmatsahu5329
    @hirmatsahu5329 6 лет назад +1

    Thanks sir

  • @atozonlineservice3751
    @atozonlineservice3751 6 лет назад +1

    So thanks sri

  • @vipinrokers9699
    @vipinrokers9699 6 лет назад +1

    Thnks sir जी

  • @parmodkumarnnm
    @parmodkumarnnm 5 лет назад

    Excel mein date of birth se date of retirement nikalni hai saath saal Puri hone par lekin jinka Janam ek tarik ko hua hai aur ke Daman pichle mahine ke last working day ko honi hai is par koi formula bataye

  • @shoebfarooqui4061
    @shoebfarooqui4061 6 лет назад

    Sir ji (excel past spacial ) pe koi video Bano

  • @neerajparsad8202
    @neerajparsad8202 6 лет назад

    Bhai saab farmula formet ki video bna k dehaiya plz

  • @shortstatus336
    @shortstatus336 6 лет назад

    Sir jb HM excel Mai two rows to freeze panes mai ja Kar top rows kr latai hai sir jb HM unh rows ko merge kr Kai work krt hai to vo phle rows Mai hi dhikhata hai

  • @opgamer3d932
    @opgamer3d932 6 лет назад

    Kripya photoshop ke baare me bhi batayein

    • @mybigguidehindi
      @mybigguidehindi  6 лет назад

      फोटोशॉप के बारे में कुछ वीडीयो अपलोड किये जा चुके हैं आगे भी जल्‍द ही आयेगें आप नीचे लिये गये लिंक पर क्लिक कर देख सकती हैं
      फोटोशॉप के सभी वीडीयो यहॉ देखें - goo.gl/AVsjLZ

    • @aashutoshpandey9356
      @aashutoshpandey9356 6 лет назад

      hi

  • @mahendradangwal
    @mahendradangwal 6 лет назад

    Esse pahle ni pta tha ye formula

  • @VishalSingh-ft4vz
    @VishalSingh-ft4vz 6 лет назад

    Please sir pivot table ka video dal do complete use of pivot table plz sir plz plz plz ....

  • @fineidrish
    @fineidrish 5 лет назад

    Excel ke sabhi formule detail me bataye

  • @somanarayanverma3688
    @somanarayanverma3688 6 лет назад

    🙏🙏🙏

  • @syedimran9406
    @syedimran9406 5 лет назад

    Dear mera ek sawal ha aap se meri joining date 12/11/2018 ki ha tu main chata hon k monthly mojhe remind karaye k mojhe har month ki 12 ko salary colect karni ha kya ye posible ha excel main kya koi asa formula ha please reply,

  • @kamaljeetsharma5573
    @kamaljeetsharma5573 5 лет назад

    जोड़ में भी काम करेगा क्या सर

  • @glitterworldcreation
    @glitterworldcreation 6 лет назад

    This is a good one.
    But the same thing can be done with sumproduct function in ms excel.

  • @bhaweshkumar1160
    @bhaweshkumar1160 6 лет назад

    Kya aapko nahi lagta hai ki yadi youtube ke fullscreen mode me like button hota to jyada like milega? Ha maine kayi bar aapke and other subscriber ke video ko like karna chaha but main kar nahi paya, because main back nahi jana chahta tha aur main next video dekhne laga.

  • @iqbalkhan1245
    @iqbalkhan1245 5 лет назад

    Hello sir,
    गूगल ड्राईव में create excel sheet में 1st sheet का same data more 10 sheet me paste करने के लिये कोई shortcut trik हो तो plz बताये.

  • @jmsfun2769
    @jmsfun2769 6 лет назад +4

    Sirji Namaskar
    आपने जो ऐरे का फार्मूला एक्सप्लेन किया है बहुत पावरफुल है मेरा सारा प्रॉब्लम हट गया मुजहे एक्सेल में टोटल जल्दी से हो जाता है प्लीज शेयर योर कांटेक्ट नंबर

  • @MyTechnologyankur
    @MyTechnologyankur 6 лет назад +1

    nice

  • @abhisheknair3d
    @abhisheknair3d 6 лет назад

    Helo ABHIMANU sir, I need one help mujhe kisi rows wise One or Two hi record show karni hain baki records display nahi ho.like Filter.any options with formula?

  • @rishigohiya2794
    @rishigohiya2794 6 лет назад

    सर ms word , excle में ऐसा कुछ बताये कि जब मे अपनी फाइल बना के मेल करू तो दखने वाले उसे वास देख सके उसमे किसी प्रकार का परिर्वतन ना
    कर पाये
    धन्‍यवाद

  • @navneetmehra8878
    @navneetmehra8878 5 лет назад

    Sir kya hum array formula ko VLOOKUP pr b use kr skte h...

  • @ncgyan22
    @ncgyan22 6 лет назад

    sir agar text aur number dono sath me hai to kaise formula se sum kare
    like
    20jan + 20dec + 20 feb
    ko sum karana hai excel me, dono sath me likha hai
    text aur number dono
    but different different text hai
    20jan
    20feb
    20dec
    =

  • @ramesh8660
    @ramesh8660 6 лет назад

    sir, How to write hindi font in excle. and how to change english font and hindi font by shortcut keys in ms word or excle

  • @SatishKumar-iq3lb
    @SatishKumar-iq3lb 6 лет назад +1

    Sir koi y sa softwar bata i y na jis se computer me backspece Lock ho ja y...pl ...pl...

    • @mybigguidehindi
      @mybigguidehindi  6 лет назад

      आप आप टाइपिंग स्‍पीड बढाने के लिये और एक्‍जाम की तैयारी के लिये बैकस्‍पेस से बचना चाहते हैं तो वीडीयो देखें - goo.gl/hKXA7a
      और यदि आप बैकस्‍पेस को किसी एप्‍लीकेशन की मदद से डिसेबल करना चाहते हैं तो आप SharpKeys डाउनलोड कर सकते हैं 👍

    • @SatishKumar-iq3lb
      @SatishKumar-iq3lb 6 лет назад

      Jabab de me ke li y thanks sir ..mere computer me 32 bit h aar aap ne jo software bata ya h o install nhi ho r ha h (software 64...bit ka h

  • @ujwal9839
    @ujwal9839 5 лет назад

    Sir mujhi yesa formula bato jo mujhi e marketi Mai help kare Jaise ke hum price change kar Sakti hai sir pls aiysa khuch baato

  • @mukeshkumarbedia7152
    @mukeshkumarbedia7152 6 лет назад

    XL me kitna formula hai

  • @BD-nr8zx
    @BD-nr8zx 6 лет назад

    sir G,
    mera ek problem h,excel m help kr de...🙏

  • @RajKumar-nm4ui
    @RajKumar-nm4ui 6 лет назад

    Sir how to create index of all workbook in a file please guide me

  • @jmsfun2769
    @jmsfun2769 6 лет назад +2

    Sirji spoul ho gaya meine shift +control enter use nahi kiya tha isliye
    muzhe 1 sheet se 2 shhet mein formula lagana kya karu

  • @rina1592
    @rina1592 6 лет назад

    I want to know how you have that windows launcher on your screen desktop at the beginning???

  • @balvinderkumararora222
    @balvinderkumararora222 6 лет назад

    Sir ji english mei text likha kijye

  • @adityadev4833
    @adityadev4833 5 лет назад

    Sir Mera photos ek app private zone me store tha galti se delete ho gaya hai . Maine bahut try Kiya but restore nahi ho paya hai . What's app me hai but wo download nahi ho Raha hai .file missing bata Raha hai

    • @adityadev4833
      @adityadev4833 5 лет назад

      Google drive me store nahi Kar paya tha . Kaise mai aapne sare delete pic ko restore kar sata Hun.aur aage mai aapne sare important pic ko long time tak safe rakh sakta Hun .aur jarurat pade par use use Kar sakta Hun. Please jaldi se jaldi batane ka kast kare. Mera Gmail account hai devaditya38@gmail.com

  • @sanju9341
    @sanju9341 6 лет назад

    Sir hindi m fast typing kaise kare excel m

  • @ajmalshahtravelling7088
    @ajmalshahtravelling7088 6 лет назад

    asaa

  • @deepdhillon6434
    @deepdhillon6434 6 лет назад

    Hi I need ur help. Excel main kaam karti karte jab cell up down move karti hu arrow key se to ek dark black arrow Aa jata hai jisme 4 arrow hote hai or ye bahut fastly page scroll kar deta hai or page 1st row se no. Of thousands row tak Bagh jata hai. I'm doing live job sitting with my boss so it make me feel embarrassed. Tell me solution Kaise hte ga ye arrow. Pehle nahi ata tha I think I clicked by mistake on any option and now can't find out.

  • @chandraprakash-ji8cp
    @chandraprakash-ji8cp 6 лет назад

    kishi bhi date ka kailender kaise banaye

  • @arunkamble5937
    @arunkamble5937 6 лет назад

    Sir excel mai ek problem aari hai table mai kuch bhi type karne per 0.01 aisa dikha rha hai

  • @gulamhussain4727
    @gulamhussain4727 6 лет назад

    Hi sir,
    I need ur help : Suppose I have below data
    "JpmorganDefferal20%400,500,70%"
    Above data are in one cell without space and I need this data as " JPMorgan Defferal 20% 400 500 70% " in different cells. How may I suppose to do this. Please help.
    Thanks in advance

  • @jamshedkhan4674
    @jamshedkhan4674 6 лет назад

    bhai English me type karain take sara bharat dekh sake.

  • @vinayakpotadar4093
    @vinayakpotadar4093 6 лет назад

    Sir word letter format Nalli mail merge Annu how to link excel sheet , how to 100 letter above link excel sheet please tilisi.