waimea
12-28-2018, 10:01 AM
I have posted a similar thread on mrexcel.com however, there were no responses. https://www.mrexcel.com/forum/excel-questions/1081986-named-ranges-same-formula-gives-different-values.html
I have created 10 dynamic named ranges but when I evaluate the ranges the evaluate to different ranges using the same formula.
This formula gives me different results and I can't figure out why?
=OFFSET(Data!$E$14; 0; 0; COUNTA(Data!$E:$E)-2; 1)
Dynamic range1 evaluates to E14:E2233 and dynamic range2 evaluates to F14:F2234???
What am I doing wrong? And what is the best way to create dynamic named ranges for use in formulas? I am trying to create dynamic named ranges for use, mostly, in COUNTIFS and SUMIFS.
I have created 10 dynamic named ranges but when I evaluate the ranges the evaluate to different ranges using the same formula.
This formula gives me different results and I can't figure out why?
=OFFSET(Data!$E$14; 0; 0; COUNTA(Data!$E:$E)-2; 1)
Dynamic range1 evaluates to E14:E2233 and dynamic range2 evaluates to F14:F2234???
What am I doing wrong? And what is the best way to create dynamic named ranges for use in formulas? I am trying to create dynamic named ranges for use, mostly, in COUNTIFS and SUMIFS.