Offset Function in Excel

Offset Function in Excel

Offset Function in Excel

Offset function in Microsoft Excel is a function which we can also call as lookup function, there are many ways to use it, but this offset function blog post will teach you two easy ways to use offset function. I will get the idea to do.

FORMULA

=OFFSET(Table Start Point, Row Number, Col Number, height, width)


In the first example, we have used the offset formula in such a way that you can call the quarter amount of which year.




In the second example, we used the offset formula with the sum formula and by using it we can get the total of any year.




Now I hope that after understanding these two examples you will have understood the offset function in excel.

FORMULA FILE

Post a comment

0 Comments