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