OFFSET function question.

[A3Driver]

To capture the last cell in a check register to report to another worksheet, I use the following forumula:

=OFFSET(worksheet1!$H$1,COUNT(worksheet1!$H:$H)-1,0,1) where H is the column containing data.

I'm having difficulty understanding the argument, COUNT(worksheet1!$H:$H)-1. You can't get too elementary in your explanation. I do not undertand what the -1 means.

Thank you in advance.

[daddylonglegs]

COUNT simply counts numbers so assuming you have only numbers in column H starting at row 1 and ending at row 10 then that part would give you 10 but the last cell with a number is 9 rows down from H1 so you need to subtract 1 from that to get H10.

For the last number in a range it might be easier to use a formula like this

LOOKUP(9.9E+307,worksheet1!$H:$H)