by

Offset Function in Excel

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.

1589920184 156 Offset Function in

1589920185 984 Offset Function in

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.

1589920186 516 Offset Function in

1589920186 772 Offset Function in

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

FORMULA FILE

Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

News Feed