Forum Discussion
Using Index Counta to set up a dynamic range is not returning the correct value, but sing offset doe
I have a worksheet that is doing a ton of calculations so I am trying to streamline it a bit so it will be more friendly to slower computers, Originally I set up dynamic named ranges using offset OFF...
Dichotomy66 , perhaps it shall be
('FLOP DATA'!$A$13:INDEX('FLOP DATA'!$A:$A, COUNTA('FLOP DATA'!$A:$A)+13))
or so, index starts from first row and you need to add some offset.
In general with dynamic ranges OFFSET is more easy in maintenance (at least for me), but INDEX is much better from performance point of view. Thus on small ranges it doesn't matter what to use, but on relatively big ones INDEX is definitely more preferable.
That does seem to work I will have tp test is a lot.On this worksheet the data set is replaceable and can be anywhere from a 30x 8 array to an 1177 x 8 array . Also I am using about 14 named ranges so this is especially where I am trying to get rid of offset though it is super easy to use