Offset formula in excel hindi

Teachtoeach presents a wonderful video “how to use Offset function in excel hindi. This excel tutorial explains you offset formula in excel with syntax and examples.

With the help of this video you can use :

1) Offset formula in excel 2016
2) Offset formula in excel 2013
3) Offset formula in excel 2010

A OFFSET function returns a reference from the range where row and columns intersect which a user enter in to formula.

SYNTAX of OFFSET Formula =OFFSET( range, rows, columns, [height], [width] )

Parameters or Arguments

Range - A range from where you want to start the offset formula
Rows - Which row you want to fetch. This can be a positive or negative number.
Columns - Which column you want to fetch This can be a positive or negative number.
Height - Optional. It is the number of rows that you want the returned range to be.
Width - Optional. It is the number of columns that you want the returned range to be.

Here I teach you this offset function in hindi with the help of 3 question.

1) How to use simple offset – formula use : =OFFSET(D2,3,4)

2) How to get sum of last 3 row by using offset - formula use : =SUM(OFFSET(D2,COUNTA(G2:G7)-3,3,3,1))

3) How to get average of last 4 column by using offset - formula use : AVERAGE(OFFSET(D2, 4,COUNTA(D6:J6)-4, ,1,4))

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 youtube, only just few videos are available on this offset formula topic in hindi.

Thanks for watching. It is humble request to you please subscribe my Channel to learn different tips and tricks of excel in hindi by clicking on this link    / teachtoeach  

Some popular videos-:

1) Index and Match formula in excel hindi -    • Index and Match formula in  excel hindi  

2) Split first middle and last name by using formula in excel hindi -    • Split first middle and last name by using ...  

3) Use of hlookup with match formula in excel in hindi -    • Hlookup Match formula in Excel Hindi  

4) Create Dependent Drop Down List in Excel Hindi -    • Create Dependent Drop Down List in Excel H...  

5) How to make a picture lookup in excel -    • How to create a picture lookup in excel hindi  

6) How to make speedometer in excel hindi -    • How to make a speedometer in excel hindi  

7) Excel datedif formula in hindi -    • Datedif Formula in Excel Hindi  

8) Excel countifs formula in hindi -    • Countifs Formula in Excel Hindi  

9) How to use sumproduct formula in excel -    • Sumproduct Formula in Excel Hindi  

10) Relative Absolute and Mixed Cell Referencing in Excel -    • Relative Absolute and Mixed Cell Referenci...  

11) Excel Logical Functions IF AND OR NESTED IF in Hindi -    • Excel Logical Functions  IF AND OR NESTED ...  

12) Reverse Lookup Formula Vlookup with Choose Function in Excel -    • Reverse Lookup Formula Vlookup with Choose...  

13) 2D-Two Dimensional Lookup Formula Vlookup with Match in Excel -    • 2D-Two Dimensional Lookup Formula Vlookup ...  

14) How to consolidate multiple worksheets into Pivot Table -    • How to consolidate multiple worksheets int...  

15) How to use Vlookup formula in Excel 2013 Hindi By TeachToEach -    • Vlookup Formula in excel hindi  

16) Mail Merge in Word -    • Use of Mail Merge in Hindi