Hi,

I would suggest to look into two possibilities to pick the one which
best suits your needs.

1. If the number of rows is different in each column, but known and
therefore stored somewhere, I would recommend using OFFSET (Nbrows, 0)
in your formulas

2. If the above is not possible, then I would use Define Name to locate
the last cell and then use it in your formulas

Hope this is clear enough
Cheers
Carim