Shanan212
asked on
Dynamic named range formula
Hi,
I always have data alike this
So I always have data ending with a zero 1 row below the last data. It could be 100s of lines.
Eg: I could have data from
A2 to A982
and then have a zero (0) in line A984
What I want to do is create a dynamic named range that will grab just the data part and omit the zero and the space above it based on formula only (currently I am doing it via VBA and want to eliminate vba)
Thank you in advance!
I always have data alike this
HEADING
DATAA
DATAB
DATAC
DATAD
DATAE
0
So I always have data ending with a zero 1 row below the last data. It could be 100s of lines.
Eg: I could have data from
A2 to A982
and then have a zero (0) in line A984
What I want to do is create a dynamic named range that will grab just the data part and omit the zero and the space above it based on formula only (currently I am doing it via VBA and want to eliminate vba)
Thank you in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
^ That worked; instead of -2, I changed it to -1
Thanks!