Array Formula in Excel Hindi

TeachToEach video on How to use array formula in excel in hindi. This tutorial teach you array formula in detail with examples.
Some of the topics which we cover in this video are
1. Array with SUM formula
2. Array with TRANSPOSE formula
3. Array with MID formula
Array is a not formula in itself but if you used this formula with other then you convert a simple formula into advance formula.
You can make an array formula by pressing CTRL + SHIFT + ENTER.
It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down.
On TH-cam, only just few videos are available on this topic of excel array formula in hindi.I am planning to add some technical stuff also. I am not a guru of excel but trying to become a greatest learner of excel.
Thanks for watching. It is humble request to you please subscribe my Channel / teachtoeach
Some popular videos-:
1) Excel vlookup formula error #NA #REF #VALUE in hindi - • Excel Vlookup Formula ...
2) 3 Tips to make easy Vlookup Formula in Hindi - • 3 Tips to make easy Vl...
3) Concatenate Formula in Excel Hindi - • Concatenate Formula in...
4) How to calculate Shrinkage and Attrition rate Formula in Excel Hindi - • How to calculate Shrin...
5) Double VLOOKUP in Excel Hindi - • Double Vlookup in Exce...
6) Split first middle and last name by using formula in excel hindi - • Split first middle and...
7) Create Dependent Drop Down List in Excel Hindi - • Create Dependent Drop ...
8) How to make a picture lookup in excel - • How to create a pictur...
9) Relative Absolute and Mixed Cell Referencing in Excel - • Relative Absolute and ...
10) Excel Logical Functions IF AND OR NESTED IF in Hindi - • Excel Logical Function...
11) Reverse Lookup Formula VLOOKUP with Choose Function in Excel - • Reverse Lookup Formula...
12) How to consolidate multiple worksheets into Pivot Table - • How to consolidate mul...

[@amitthesinger]

Amazing trick of Array Formula

[@TeachToEach]

Welcome

[@syedzaidi8929]

Sir, very good I understand esly thank u so much.

[@TeachToEach]

Thanks for the comment Syed

[@hareshparkara522]

good explained for easy learn sir

[@TeachToEach]

Welcome Haresh.

[@srikantbiswal1077]

Hello...I watched this array formula video today. Your's teaching style excellent. Keep it up. As per your voice you are very helpful person. God bless u Boss.

[@TeachToEach]

Thanks Srikant for Appreciating, Specially for noticed my voice apart from ARRAY Formula.

[@CryptoHustleHQ]

Thanks learning new formula every time I watch ur video

[@TeachToEach]

Welcome IMRAN, comments from my viewers motivate me to make a new video on my channel.

[@nikitaverma8241]

Sir aaj ka topic bahut hi jayada acha tha thanks for this video sir

[@TeachToEach]

Bahut Bahut Shukriya Ravin

[@saurabhyash1986]

got the file...excellent response, worked on it. Thank you so much Ashish. Please upload video to separate the names or words in a cell to different cells, like to separate the first name, middle name and last name from one cell.

[@TeachToEach]

Do you need a separate for all the name split?

[@ZindagiTechnical]

Sir you can use the function text to column to separate names and split them into first name middle and last name......
Thanks to teach to each for such nice videos

[@RanjeetKumar-vd3lh]

very usefull command lot of thanks

[@TeachToEach]

Welcome Ranjit

[@TeachToEach]

Don't Forget to Like , Comment and Subscribe on our Video

[@PankajKumar-cj2cg]

This video very helpful to us

[@amitdas6499]

Very Nice Sir
Really

[@TeachToEach]

Thanks for the comment Amit.

[@tapasinayak3826]

Thanks , very nice

[@TeachToEach]

Welcome Tapasi Ji.

[@rutviktidke07]

Great video 😊😇

[@ZindagiTechnical]

Very nice video sir.......Which software you use to show keystrokes and highlight selection by red selection

[@TeachToEach]

Camtasia

[@ZindagiTechnical]

Thank you sir
I really like your videos sir
Maine adca kiya hai
Please advice me how to increase views and subscribes sir
Plz

[@chetanbhardwj9486]

Thank you boss

[@TeachToEach]

Welcome Chetan

[@farhansaifi9823]

Very good formula

[@TeachToEach]

Thanks

[@sharafhusain645]

I am subscribed you're channel

[@TeachToEach]

Thanks Sharaf

[@umeshyadav-ly6rr]

Sir I got it. thanks so much for it

[@TeachToEach]

Welcome

[@prabhatsaurabh8148]

Very nice video

[@manojkushwah1783]

Nice video sir

[@TeachToEach]

Thanks for the comment Manoj ji.

[@prisha7972]

Mera phla comment h sir plz reply

[@laxmipradhan785]

Thank you sir for good teaching
Can we auto fill accordingly same attendance format from another excel sheet having different months

[@TeachToEach]

Yes you can with the help of Vlookup+Match.

[@MohitSharma-sl5oo]

Tnx for helping us boss keep learning sir

[@TeachToEach]

Yes for sure Mohit Ji.

[@SagarUghadeVlog]

Super Duper BRo.. can you also give some more example of BI level

[@TeachToEach]

Currently not have any data for BI

[@amarjeetkaur9706]

Thanks sir

[@lalchandsaini7446]

My question is that I want to replace the series of numbers separated by _ (like that 9_1) if go to find and replace then it converted into date format ... it's just about only one number but I have a lots of Number that converted into date ...(like that 09-Jan) , I have tried with change the format of the cell but no use..
can u suggest me a formula or any other way by using that I can do once in all.

[@TeachToEach]

Do one thing, use text to column and divide into separate cell with "_" then your underscore will removed and then merge with the concatenate formula. I hope this technique will help you.

[@madhukarsidam1]

excellent formula vlook array

[@TeachToEach]

Yes

[@upgradetechnicalskills3392]

Sir it also very useful for fantastic teaching style. But I have one request to you that I can't solve this problem. Problem is I want to automatically days count with minus like one future date 12/11/2017 to 12/11-2018 in between how many days are pending and day by it has to be minus.

[@TeachToEach]

Thanks for Appreciating my videos, Kurban please share your Email-ID so that i shall share a sheet with formula to get difference betwreen two dates.

[@irfanshaikh-lw2nm]

Yes got it

[@TeachToEach]

Welcome

[@rajeshchoudhary2520]

Nice video

[@TeachToEach]

Thanks

[@SanviPatil2019]

Arrey formula bahot hi badhiya he sir

[@TeachToEach]

Thanks Vikas

[@rinkuvyas6916]

super sir

[@TeachToEach]

Welcome Rinku

[@AmitKumar-jv4sw]

nice ..

[@TeachToEach]

Thanks Amit

[@prisha7972]

Nice sir

[@MrGaurav360]

I have a "TEXT" and I want to search that specific text in the worksheet and get the cell address of that specific text using an excel formula, how can I do it, please help if it's possible !

[@arijeetkumarsharma226]

Awesome

[@kusumnautiyal1332]

Waw nice

[@TeachToEach]

Thanks Kusum for the comment

[@kusumnautiyal1332]

@@TeachToEach it's my pleasure sir

[@AmirKhan-bw7ys]

Nyc sir

[@TeachToEach]

Thanks for the comment Amir Ji.

[@mumtazbegum9357]

Good bro

[@mohdbadruddin6784]

Very nice video!Sir main mobile pe excel use karta hu uspe array ka formula kaise use krengeplease help

[@babarqureshi5043]

Sir kindly make the hyperlink video

[@mukeshpandey1536]

use full video

[@TeachToEach]

Thanks Mukesh

[@khemrajrana7322]

Nice sir ap ek chez bataiye ki 2007 me 2 excel sheet ek sath kese open kare rply

[@gagoindiagogo4542]

Good

[@TeachToEach]

Thanks for the comment Brajendra Ji.

[@nayacterajeev]

Nice

[@TeachToEach]

Thanks for the comment Rajeev Ji.

[@krsharma67]

Thak you Sir

[@TeachToEach]

Welcome Kailash

[@sunitkatiyar7849]

Sir, Video is Good , kindly sent me its practice sheet .

[@TeachToEach]

Please share your Excel Sheet Sunit

[@irfanshaikh-lw2nm]

Hi we want some vlookup formulas

[@TeachToEach]

Please check your inbox, File has been sent to you Irfan

[@saurabhyash1986]

Bro need your help in a data..how to contact you

[@TeachToEach]

You can mail me on [e-mail]

[@monikakarar635]

Please pivot table, normal table and chart apply

[@ajmalshahtravelling7088]

wel

[@TeachToEach]

Thanks Ajmal Bhai

[@kanhucharanapanda8705]

Please upload all financial and auditing formula.

[@TeachToEach]

Yes i will try to make a video on your topic also.

[@PankajKumar-cj2cg]

Sir I need vlookup video or fornula

[@white_devil_official515]

Please share this sheet sir...

[@laxmipradhan785]

Kindly help me with a example

[@pradeepsurve5775]

how to use double formula (formula in formula)

[@TeachToEach]

It is a little bit difficult task .You have to think out of the box. I Shall try to make a video on how to think to make a formula in formula.

[@prisha7972]

Kindly send me practice sheet

[@arunpandey4083]

Sir mere ko serial number sikhna
Mera cable network ka kaam hai mera data lag bhag 10 thousand k karib or building ko separate rakhne k liye row m gap rakhna padta hai
Abhi problem y hai ki jab main serial number data hu to Khali row m bhi number ate hai
Plzz help me
[e-mail]

[@TeachToEach]

Please check your inbox Arun, File has been sent to you

[@manojmalhotra7052]

Very nice video

[@amandeepsinghsaini2476]

Good

[@TeachToEach]

Thanks for the comment Amandeep Ji.

[@anand9985]

Thanks sir

[@TeachToEach]

Dayanand i m not sir you can call my name (Ash Rawat)

[@Ajayaherkar53]

Nice

[@TeachToEach]

Thanks for the comment Ajay.

[@renusingh1577]

Nice

[@TeachToEach]

Thanks for appreciating my Every video.

[@drankusharmathewolverine]

Nice

[@TeachToEach]

Welcome Anku bhai

[@drankusharmathewolverine]

Keep going on