Defining Named Range for Lastrow in a specific column
No range is being defined when I enter this. Help me to understand how this
is supposed to work though.
Thanks,
Barb Reinhardt
"Ron Coderre" wrote:
Hi, Barb
Try something like this:
=OFFSET(PP!Goal,1,0,LOOKUP(10^99,PP!$C:$C,ROW(PP!$ C:$C))-1,1)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Barb Reinhardt" wrote:
I want to create a named range (I'll call it GoalList) and I've tried to use
something like this:
=OFFSET(PP!Goal,1,0,COUNTA(PP!$C:$C)-1,1)
Unfortunately, there are blank values on column C, so I don't really get to
the last row in the range. I know how to do this with VBA, but I need a
named range. Can someone assist?
Thanks,
Barb Reinhardt
|