In this tutorial, you will learn **how to use the OFFSET function in Excel**.

The offset function returns a reference to a range that is a given number of arrows and columns away from a given reference.

In our example, we will want to check the last entries of column A and column B, the Date and the Closing Rate respectively.

**Step 1.** Position the cursor where you want the result to appear.

**Step 2.** Type the following

=OFFSET(A1, COUNTA(A:A)-1, 0)

And hit Enter. The result is brought automatically.

**Step 3.** We will do the same with the next field, Closing Rate.

Type the formula:

=OFFSET(B1, COUNTA(B:B)-1,0)

The result will return the last field of the column B.

**Step 4.** Experiment with adding more: your calculations will update.

**Result:** Congratulations, you have learned how to use the OFFSET function in Excel.