You are outstanding... feeling glad to visit our RUclips channel thankyou...no matter i is Many years ago videos but information and your efforts for explaining everything is Life time..god bless you 🙏🙏🙏🙏🙏🎉❤
Dear Sir, Aapko mera saadar pranam! Sir maine youtube par kaafi videos dekhi par mujhe sahi se kuch samajh nhi aya tab randomly aapka videos mila sir G jaise Aapne playlist upload kari hai me step by step waise hi videos dekh rha hu sir g inse mujhe bahut kuch sikhne ko mil rha hai aap itna acha kaam kar rahe hai bhagwan aapko khoob lambi umar de aap humesha khush raho sir aaj ke time itna kon wo bhi free of cost padhata hai Sir pehli baar kisi ki videos par comment kar rha hu kirpya accept kare or aashirwad de again Thanks you So much Sir ❤
Thank you so much sir what a you teach, All topic are understanding to very easily. i have been watching continuously for back 8 days so excel ko lekar mere andar kaafi jyada improve ment hua hai ,so ,mai aapko again Dil Se i am saying thank you so much sir , you are the best trainer for me.
Sir, Hlookup with sumproduct wala video hai usme aapane jo array me row numbers manually diye, but gar data volume me ho to kya kare..mai bhot koshish kar raha hu please guide me
Thank u so much sir , i am learning new topic everyday by u sir ❤️ and adding value in my own life as well as others life 🙂 Sir i am becoming expert in excel day by day just because of you 🤗🙏
Sir in Q.2 if you are taking range for only one row i.e. from B7:F7 and freezing it, how it is showing result for all the rows and columns. In my sheet it is showing correct result in just one row and repeating it after that. Time starts from 5:50
Sir mere system me agar enter press kre to bhi outcome aarha h Max improvement ka and ctrl +shift +enter se bhi aarha hai. Aisa kyuu ?? Can you Help me.
Thank you so much for my new learning Lekin ek request hai thoda topic par dhyan do Jo itna bich me faltu ka bolte rhte ho sach me wo bahut jayada irritating hota hai please ise suggestions ki trha lijiyega. Aapki video achhi hai lekin please topic par focus Karo mtlb bolo kam karo jayada
Aapke Gyan bhare suggestions ke liye dhanyawad... Yadi aap sirf random video dekhne ke liye is channel par aaye honge to sab befaltu aur irritating hoga...is channel par JAADOO video nahi paye jate hain..lekin in depth Learning krne ke liye Jude hain to video in sequence dekhen..phir apko pata chalega ..ye faltu ki baten aur irritating baten jo apko lagi hain wo kya value add karte hain life me Main samajh sakta hu apke paas time bht kam hai isliye aap kam time me kuch amazing karna chahte hain.but yahan padhna hai to patience rakhna hoga apko..nahi to Jadoo video bnane wale bht saare channel hain..apna keemti samay kharan mat kariye Kudleep ji😊😊❤️❤️👍
@@Innozant sir aap to lag rha hai naraj ho gye Main aapki video kafi time se dekh rha hun mene sikha bhi hai kuchh kuchh. Or please aapko Mera suggestions galat laga to sorry but Mera koi esa intension tha nahi. But I love your video bura mat maniye sir video short kijiye 😉
@@Innozant sir maine advance excel kiya hai array bi kiya hai but apka formule lagane ka treeka different hai isliye muje samjh toh ati hai sath sath je bi pta lag jata iske ese bi lagah sakte aa isliye sir thnq so much
Sir, I have Office 365 and I was doing this for practice but I have getting same results using the array function by Enter only, could you please let us me know that why it's working without Ctrl + Shift + Enter?
Sir ek baat samaj nhi aae ek ex me large nikalne me we can use both "enter"& "CTRL+SHIFT+ENTER" and result are same but why it is not possible with "length function"
Already maine bataya hai dear ki large aur sumproduct ko ctrl shift enter ki jarurat nhi hai wo enter se executive ho jayenge.but len standard function hai wo array function nhin h isliye use ctrl shift enter se executive krne ki jrurat hogi
Can u make a video of students position those that are same score have the students out of 100 from different subjects in school plzzzz on request vijaan
Hahaha..Koi Nahi GAGAN ..Pehle to Corona ne aur ab Aplogon ke pyar me jabrdsti aane ko majboor Kar Diya hai....ab aa hi gye Hain to ye Safar bht door tak chalega Saath..aap bataiye...chalenge Siphar se shikhar tak ke Safar par mere saath❤️❤️❤️🙏🙏🙂🙂😀
Ye 1 to 100 invoice number hai kya?apko alag alag invoice no ka payment pata karna ha ek hi party ka? Ya kuch aur puchna chahte hain?better hoga aap sample ques bhej dein to jyada acha help kar payenge aapka
Ms office 2021 m koi jarurat nhi h Ctrl + shift + enter press krne ki only enter press krne pr bhi result same aa rha h wo automatic process kr leta h 😊
Sir aapka paid course h kya ...jisme pen drive mil Jaye ....ya phir .... videos mil Jaye Jo hm kbhi bhi dekh ske ...with certificate ...or sir yeah jo ISO certificate bna kr dete h RUclips Wale iska interview m koi benefit h ya phir .... CCC krna best h
You are outstanding... feeling glad to visit our RUclips channel thankyou...no matter i is Many years ago videos but information and your efforts for explaining everything is Life time..god bless you 🙏🙏🙏🙏🙏🎉❤
Thanks dear..Really means a lot to me
Dear Sir, Aapko mera saadar pranam! Sir maine youtube par kaafi videos dekhi par mujhe sahi se kuch samajh nhi aya tab randomly aapka videos mila sir G jaise Aapne playlist upload kari hai me step by step waise hi videos dekh rha hu sir g inse mujhe bahut kuch sikhne ko mil rha hai aap itna acha kaam kar rahe hai bhagwan aapko khoob lambi umar de aap humesha khush raho sir
aaj ke time itna kon wo bhi free of cost padhata hai Sir pehli baar kisi ki videos par comment kar rha hu kirpya accept kare or aashirwad de again Thanks you So much Sir
❤
God bless you dear..Have a wonderful career ahead..Keep growing
yours tutorial very super and easy understaning
Thank you so much sir what a you teach, All topic are understanding to very easily. i have been watching continuously for back 8 days so excel ko lekar mere andar kaafi jyada improve ment hua hai ,so ,mai aapko again Dil Se i am saying thank you so much sir , you are the best trainer for me.
Thanks dear,Acha lga sunke aapse ki apka skills improve hua hai,Step by step video uploaded hain..seekhiye aur life me aage badhiye.
सर हर बार जब मैं आपका ट्यूटोरियल देखता हूं तो मुझे कुछ नया सीखने को मिलता है | आपके वीडियो मेरे जीवन को आसान बनाते हैं|
सीखने के प्रति आपका समर्पण प्रशंशनीय है
Sir
I love you for this job ❤❤❤❤
Sir believe me that .your excellent world one ...i like all youtubes one excellent ....🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰
Thanks
Amazing sir. Maja aa gaya
Sir aap bahut acche teachers.
Thanks Raj
very inspirational and easy mode
great sir
Thanku u very much keep going
Thank you sir, i am learning new topic
Amazing channel
Sir, Hlookup with sumproduct wala video hai usme aapane jo array me row numbers manually diye, but gar data volume me ho to kya kare..mai bhot koshish kar raha hu please guide me
Superb 👌
Sir ji Dhanyawad..
nice video 👌🏻👍🏻👍🏻
Thanks Karan
amazing
nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻
Thanks Vijay
Thank you sirr
Your every video is amazing ❤️❤️
Thanks Kanhaiya for your valuable appreciation..God bless you .. Happy Learning 🙏♥️
excellent video
Great tips....
Thanks Jitendra For your wonderful feedback,Keep learning.
Sir sum large formula enter kiya toh har cell mein same values aa raha hai 6:41 time stamp pe drag karne se. Please help sir
You are awesome.
Thanks dear.. Happy learning
I like your videos becoz it is understandable and u are grrat in understanding
Thank u so much sir , i am learning new topic everyday by u sir ❤️ and adding value in my own life as well as others life 🙂
Sir i am becoming expert in excel day by day just because of you 🤗🙏
very good sir
outstanding sir
Thanks Akash ji👍❤️🙏
sir ho gya workbook calculation manual ho gya tha 😊
👍
Very informative 👍
Thanks Harivansh ,Keep watching ,Learn and share
Great Sir
❤🙏
Excellent
Thanks Bhoopendra Ji,Do Practice
I'm so happy..you learned very well
Thanks dear.god bless you
Awesome as always. Thanks
Thanks Kavita ji ❤️
nice video
We want to hear your story sir. Please share your journey.
Thanks Sir.
Thanks Tarun❤️
Thanks sirrrr
great
Control+Shift+Enter bol-bol k itna complex bna diya ki kuch smjh nhi aaya! 😂
8:52 par kya keys press ki jisse range convert hokar grouped data m show hone lga
F9 dear use to evaluate
Sir in Q.2 if you are taking range for only one row i.e. from B7:F7 and freezing it, how it is showing result for all the rows and columns. In my sheet it is showing correct result in just one row and repeating it after that. Time starts from 5:50
Which array should I use help me vijan
Sir mere system me agar enter press kre to bhi outcome aarha h Max improvement ka and ctrl +shift +enter se bhi aarha hai. Aisa kyuu ?? Can you Help me.
thank u
Thanks
sir provide same sheet what you solve the question for plz practice
Sir sql par koi video banaiye
Jald banega
Ok sir i am waiting
Gzb Sir
Thanks Pramod Ji.❤️
Thank you so much for my new learning
Lekin ek request hai thoda topic par dhyan do Jo itna bich me faltu ka bolte rhte ho sach me wo bahut jayada irritating hota hai please ise suggestions ki trha lijiyega. Aapki video achhi hai lekin please topic par focus Karo mtlb bolo kam karo jayada
Aapke Gyan bhare suggestions ke liye dhanyawad...
Yadi aap sirf random video dekhne ke liye is channel par aaye honge to sab befaltu aur irritating hoga...is channel par JAADOO video nahi paye jate hain..lekin in depth Learning krne ke liye Jude hain to video in sequence dekhen..phir apko pata chalega ..ye faltu ki baten aur irritating baten jo apko lagi hain wo kya value add karte hain life me
Main samajh sakta hu apke paas time bht kam hai isliye aap kam time me kuch amazing karna chahte hain.but yahan padhna hai to patience rakhna hoga apko..nahi to Jadoo video bnane wale bht saare channel hain..apna keemti samay kharan mat kariye Kudleep ji😊😊❤️❤️👍
@@Innozant sir aap to lag rha hai naraj ho gye
Main aapki video kafi time se dekh rha hun mene sikha bhi hai kuchh kuchh.
Or please aapko Mera suggestions galat laga to sorry but Mera koi esa intension tha nahi. But I love your video bura mat maniye sir video short kijiye 😉
Which formula should I apply
Thnq sir
Aisa lag ra hai array isi week me finish Karne Ka irada hai😀...saare topic recap jaroor karte rehna dear
@@Innozant sir maine advance excel kiya hai array bi kiya hai but apka formule lagane ka treeka different hai isliye muje samjh toh ati hai sath sath je bi pta lag jata iske ese bi lagah sakte aa isliye sir thnq so much
👍👍
Sir apka fan ban ga m to
Thanks Shree❤️
Supurb sir
thanks
sir drag karne se ek hi value a ja rha hai , video me a rha hai sir please reply
❤️❤️❤️❤️❤️
Sir , but I have run max in reference by using entre
Agar data horizontal ho to kaise nikale large
Sir, I have Office 365 and I was doing this for practice but I have getting same results using the array function by Enter only, could you please let us me know that why it's working without Ctrl + Shift + Enter?
Ms office 2021 m koi jrurat nhi h Ctrl+shift+enter press krne ki wo automatic detect kr leta h
Sir ek baat samaj nhi aae ek ex me large nikalne me we can use both "enter"& "CTRL+SHIFT+ENTER" and result are same but why it is not possible with "length function"
Already maine bataya hai dear ki large aur sumproduct ko ctrl shift enter ki jarurat nhi hai wo enter se executive ho jayenge.but len standard function hai wo array function nhin h isliye use ctrl shift enter se executive krne ki jrurat hogi
Can u make a video of students position those that are same score have the students out of 100 from different subjects in school plzzzz on request vijaan
i am using MS 2021 , hence it is taking directly even without ctrl+shft+entr.....!
Yes office 2021 and office 365 works on dynamic array concept
Kahane the bhai abhi tak......bahut late aaye ho RUclips pe......
Hahaha..Koi Nahi GAGAN ..Pehle to Corona ne aur ab Aplogon ke pyar me jabrdsti aane ko majboor Kar Diya hai....ab aa hi gye Hain to ye Safar bht door tak chalega Saath..aap bataiye...chalenge Siphar se shikhar tak ke Safar par mere saath❤️❤️❤️🙏🙏🙂🙂😀
Sir
Inv. No
1 to 100 amount Hai party payment karti Hai 3 bill ka payment ek sath kis tarah find Karnge ke kon si 3 bill ka paymen aaya hai
Ye 1 to 100 invoice number hai kya?apko alag alag invoice no ka payment pata karna ha ek hi party ka? Ya kuch aur puchna chahte hain?better hoga aap sample ques bhej dein to jyada acha help kar payenge aapka
please explain this Question properly i will help you
I am waiting vijan
How to share an Excel file which contains an array formula?
sir ek chhota sa excel sheet h sir main wo apko dikhana chahta hoon qki usme ek problem aa rha h plz koi solution dijiye
Ok .@innozantofficial telegram id par share kriye
@@Innozant sir is naam se 2 group show ho rha h ek me sirf join ka option h usme 380 member hai??
@@Innozant or share ka option to hai hi nhi hum apko mail kr de sir????
@@kartavyatiwari8583 @innozantofficial telegram id par bhejiye group par nahin
@@Innozant sir maine bhej diya h plz check kr lijiye
This excel version name
Ok sir
Aur bahut sari criteria ho usme se ki ek ka data large 1se 5 tak nikalna ho to
=SUM(LARGE($B$2:$F$2,{1,2,3})) drag karne se nahi a rha sir kya kana hogan please
Remove $ symbol and try
Without using Max function Values Returning Maximum Difference Count
Formula.
{=D5:D9-C5:C9}
But how ?😊..Max required na?
This will return the 1st value only. If some other value are largest, it will not be shown.
Excel મા કોઈ celll મા નંબર લખો એટલે તેટલી જ row જોઈએ છે.....
બાકીની row hide થાય એવુ foumula aapo
Ms office 2021 m koi jarurat nhi h Ctrl + shift + enter press krne ki only enter press krne pr bhi result same aa rha h wo automatic process kr leta h 😊
Aur jahan interview Dene Gaye wahan office 2021 ya 365 na ho to ..phir kya bolen..sir offuce 365 install kar do pehle😊
😂😂.....sir m isliye kah Raha tha taki office 365 Wale to iski tension na le km s km
Sir aapka paid course h kya ...jisme pen drive mil Jaye ....ya phir .... videos mil Jaye Jo hm kbhi bhi dekh ske ...with certificate ...or sir yeah jo ISO certificate bna kr dete h RUclips Wale iska interview m koi benefit h ya phir .... CCC krna best h
@@achalrajput4173 Yes ,,use buy karne ke liye aap innozant website visit kariye ya team innozant se contact kariye
@@achalrajput4173 Aap innozant website visit kariye complete information ke liye
👏👏👏👏👏👏👏👏👏👏👏👏👏👏
Thanks Nisha❤
Hamre Dimag Se Bilkul Bahaar He
In sequence delhiye.. playlist.. random video dekhneg to prob hogi dear
In sum of 3 products do not friz arrey
didn't get your query dear
@@Innozant 2 question of this vediou ...
Please work on normal excel not on 365
Didnt get your dear.Kindly explain your query
Revision.
Like
Thanks Balaji,Keep watching , Subscribe and share to others
Score of 20 students in a school of different subjects
share sheet
Plzzz help me vijan
haaaaaaasa
liked very good
And I can send you also if you want
Plzzzz help me
Khud hi smj le
👍..samjhne ke liye sequence me content learn karna hota hai 😊
તમારો નંબર આપો સાહેબ
What the hell ??
Thanks Sir!
TQ..sir