How to Use Excel Array Formula - Examples and guidelines in HINDI│Ctrl+Shift+Enter Use in Excel 2013

[@arunkumarsinghark3024]

शानदार, ज़बरदस्त, मज़ेदार फार्मूला है array formula... 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l 🌷🌷सीखते रहो, सिखाते रहो 🌷🌷🙏👍

[@shabeermohammed2953]

Thanks, it solves my KPI table issuee

[@MrNaturalcure]

Thank you well explained what if I have multi SKU in Table adjacent 8 columns wants to count all including duplicates with their counts and list?

[@shahariarhossainpranto2185]

Thanks, it's very helpful for me

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@ComTutor]

thanks

[@adityavarma461]

You are explain of way very nice

[@SAJJAD_ALAM]

Thanks sir aap bahut achhe se samjhate hain.

[@ComTutor]

your welcome bro.

[@mzaqkrl]

Gentleman, is there any way to enter data on a pre-printed forms -XL or Word- appreciate your guidance. Thanks.

[@ComTutor]

can't print on pre-printed form.

[@dennissaji]

Humourous.. Arrey deewano

[@ComTutor]

thanks.

[@RahulKumar-ly6ly]

Sir excel me show margne vala option ko clicks karka manual margne set kaise karta ha sir margne vali line ko aaga piche kichker sir es topic par ek video pĺease sir

[@ComTutor]

bhai maine bataya naa excel mei wo line ko aage peeche nhi kar sakte wo only ms word mei hota hai, yha excel mei apko fit to wale option mei percentage diya hota hai usse margin kam ya jyada hota hai.

[@RahulKumar-ly6ly]

@@ComTutor sir ek excel me hota ha na show margne vala option ko clicks karka manual margne ki line show karti hai sir print Dana se pahle sir usme jo margne ki line aati hai print preview se pahle sir

[@nitinshukla914]

गोविन्द सर प्रणाम, Use Excel Array Formula का यह वीडियो मुझे बहोत शानदार और उपयोगी लगा सर. सभी विषयो में से जिस विषय के महत्तम मार्क्स हो उस सब्जेक्ट का केवल नाम पॉप्युलेट हो जाये ?? यह कैसे हो, कृपया करके बताये.

[@ComTutor]

इसमें Large और vlookup का फार्मूला एक साथ लगाना पड़ेगा सबसे पहले पुरे आंकड़ों में से सबसे ज्यादा कोनसा है वो जांचना पड़ेगा फिर उस नंबर से सब्जेक्ट पर vlookup लगाना होगा तो सब्जेक्ट का नाम आ जाएगा।

[@BharatKumarModibbm_111]

Google sheets में डेटा को copy as picture कैसे करते हैं, जिस प्रकार एक्सेल में Ctrl+C द्वारा करते हैं।

[@SAMEERURFMILLA]

kya mast samjhaya hai thanks ....

[@ComTutor]

your welcome.

[@nagenderachauhan7117]

How we use spinner in making report card

[@mdmunir7]

Thanks. Sir.mere pass ek workbook me 3 sheets he.teeno sheets me ek hi category ka numbering data he.mujhe teeno sheets ke no. Ko ek jagah sum karna he.categoey wise.please help.

[@ComTutor]

to ek hi tarah ke data pr pivot lga dijiye aur value mei sum le lijiye. aur ek se jyada sheet ke saath pivot kaise lagate hai uss video ka link neeche hai. kzbin.info/www/bejne/qpKmcnmKjM6cqbM

[@swatikumari-ik7eh]

Hello...I have query,I need to find number of occurences of each records in column ..with this format 35-3,45-4,1-7 show in 1st cell of of row..corresponding each column

[@praveenk1672]

swati kumari Hello Swati, you first need to list out unique items of a column ( using unique formula in Excel 2019 or using Index match countif formula in older version ). Once one column is ready with the unique items, use countif formula in second column to count their occurrence). Once both are ready, you can concat values as you need.

[@naraharimanne5240]

excellent

[@gurjitstudypoint]

sir i am gurit singh from punjab , i want leant vlookup with array formule for finding , sortage and calculation ? help me sir

[@ComTutor]

i have already made a video on this same topic. video link is below. learn more. kzbin.info/www/bejne/pHKYooFsiJqtjMk

[@deepakvaishy7754]

Great Sir

[@parulbhardwaj4562]

How to put currly bracket?

[@hemantchavan4443]

If with and, or formula use ek sath kese karte hai

[@draco1847]

nice video

[@ComTutor]

thanks.

[@arghyasarkar30]

Main ek se adhik letters yani ki aksar ko kaise ekhi cell count kar paunga.kis formula waha upoyog hoga. Ex:-a b c d e= 5 ekhi cell ke andar

[@utsavnadpara7021]

Sir ye mere laptop me formula kam nahi kar raha hai cntrl+shift+enter click karta hu to 1 cell me jo ans aata hai vahi dikhata hai 3*3 ka matrix me leta hu to usme 1 hi cell me value aati hai to muje baki ke sare cell me chahiye value to please guide me sir me excel ka kon sa setting karu jisse ye formula chale.......manually ho raha hai but cntrl+ shift+enter se nahi ho raha hai mere ko usse karna hai

[@kausikkarmakar2558]

Sir,excel worksheets fast karne ki koyi tricks hain?

[@ComTutor]

ye apke system par depend karta hai excel par nahi agr apka system jyada RAM wala aur processor wala hoga to fast kaam karega.

[@sandipanchoudhury207]

nice sir, thank u

[@ComTutor]

thanks.

[@mrmrimran1]

thanks for nice topic and pleased to see practice file.

[@ComTutor]

practice file in the description.

[@gauravsingh1044]

thanks very helpful, please make a video on dashboard

[@ComTutor]

soon i'll upload

[@rajatareq]

Thnx bro, specifically thnx for adding the sample file for practice

[@ComTutor]

thanks..

[@satscoolstyle4210]

Nice Bhai offset sikha do

[@ComTutor]

thik hai march ke ek video mei offset sikha dunga.

[@harishuuniyal]

please try to avoid any loud noise or music while video starts or between video

[@ComTutor]

its my intro bro, how can i remove my intro from my video. but okay next time i'll reduce its sound.

[@yusufkkrrolsahabsar]

Good

[@MohammadAli-ng5il]

Hi, how to create loops in excel?

[@ComTutor]

i can teach you loop in march video.

[@puneetvij8433]

Govind Sir, Stack-columns and Un-stack columns, ये Power-query का Master stroke topic भी मुझे जानना है, कृपया इस पर video launch कीजिए | ; )

[@ComTutor]

stack aur Un-stack columns mei to do ya do se jyada data ke column ko ek hi column mei karte hai. kya isi ko sikhna chahte ho.

[@puneetvij8433]

ComTutor जो Power-query के 'transform' tab में Pivot column और Un-pivot column के नाम से है |

[@ComTutor]

power query ka ribbon ek Add in Excel hota jisko jyada log use nahi karte hai. isliye iss topic ke baare mei jyada log abhi nahi jante hai.

[@puneetvij8433]

Govind Sir, मगर ये बहुत important topic और एक common problem है, Office में employee का काम आसान करने वाला है | ; )

[@kumargautam6997]

Thanx sir

[@ComTutor]

thanks.

[@kumargautam6997]

Sir Excell me form kese create karenge

[@ComTutor]

excel mei form banane ke liye maine video banayee hai link neeche hai. dekhiye. kzbin.info/www/bejne/nYbWeYysmbRsZ9k

[@deepakrawat625]

Sir maine max function lagaya aur number na chun k range chuni aur enter dabaya Pr fr bhi yeh mujhe maximum value bata rha hai Max value toh pr number maangta hai as its formula not range toh fr mera answer kaise aa rha hai ?

[@ComTutor]

ye Max and Sum Average wale formule ek number aur ek se jyada number dono tarah ke data par kaam karte hai, isliye jab aap ek number denge ya array denge dono condition mei result ayega.

[@kumargautam6997]

Sir Array का और example से bataye

[@ComTutor]

thik hai mai ek video aur bna dunga jisme lagbhag do ya teen example le lunga.

[@puneetvij8433]

Govind Sir, ज़बान के पक्के हो, धन्यवाद ! तो मैं ये समझ लूँ कि CSE और { } एकसाथ नहीं लग सकते | : )

[@ComTutor]

correct agr aap CSE use kar rhe hai to { } mat lagaiye, aur agr bracket lagate hai to to only enter kijiye.

[@ibm98852]

Exlnt

[@rajeshchoudhary2520]

Nice video