Use OFFSET and COUNT functions within Named Ranges

L

lkulchak

I am using the forumla below to prevent my graphs from dropping to
'zero' where data is not yet available over the course of weeks in a
quarter. In the past, the data has been spread across columns in a
single row. Now I have the reverse (data is within a column) and of
course, the formula doesn't retreive the data that I want. Since I'm
not clear on the underlying logic, can someone recommend a way to
'flip' the results I am getting? Thanks.

=OFFSET(Retrieve!$J$17,,,,COUNT(Retrieve!$J$17:$J$29))
 
B

Biff

If I understand try this:

=OFFSET(Retrieve!$J$17,,,COUNT(Retrieve!$J$17:$J$29))

This defines the HEIGHT where your original formula defined the WIDTH.

Biff
 
L

lkulchak

Biff said:
If I understand try this:

=OFFSET(Retrieve!$J$17,,,COUNT(Retrieve!$J$17:$J$29))

This defines the HEIGHT where your original formula defined the WIDTH.

Biff
Click to expand...
 
Top