M
Mathew P Bennett
Good Evening,
I have converted most of my vlookup functions to use named ranges rather
than cell references, using offset & counta combined in the named ranges to
specify the range - as the rows will increase as transactions are added - so
it knows to go to the last row.
However, this has drastcally increased the claculation time - 5 mins!
Am I doing something wromg?
Thank you,
Mathew
I have converted most of my vlookup functions to use named ranges rather
than cell references, using offset & counta combined in the named ranges to
specify the range - as the rows will increase as transactions are added - so
it knows to go to the last row.
However, this has drastcally increased the claculation time - 5 mins!
Am I doing something wromg?
Thank you,
Mathew