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...
Your INDEX-COUNTA formula for the dynamic range is correct, provided that A1:A12 are not blank. If A1:A12 are blank, the last 12 cells in Column A would be excluded from your dynamic range. If 11 out of the 12 cells in A1:A12 are blank, which I suspect is true in your case, then the last 11 cells would be excluded from your dynamic range, such that it only counts 63 instead of 74. To remedy the possible existence of blank cells above the starting row of your dynamic range, exclude A1:A12 through this formula:
='FLOP DATA'!$A$13:INDEX('FLOP DATA'!$A$13:$A$1048576,
COUNTA('FLOP DATA'!$A$13:$A$1048576))
='FLOP DATA'!$A$13:INDEX('FLOP DATA'!$A$13:$A$1048576,
COUNTA('FLOP DATA'!$A$13:$A$1048576))