Name range based on Cell content
Name : RangeB
Refersto:
=OFFSET($E$1,MATCH("A",$E:$E,0)-1,0,MATCH("A",$E:$E,1)-MATCH("A",$E:$E,0)+1,
1)
replace "A" in the three places with "B", "C" & "D" for the other names
Regards,
Peter T
"Abdul" wrote in message
oups.com...
I have 3 sheets with variable number of rows
Column 5 contains A or B or C or D which is sorted so that all A will
be together and all B will be together etc.
Now is there a way that i can name the range based on the column 5
content?
say i want to name RangeA for the cells haveing A's and RangeB for the
cells haviong B''s etc?
Since the number of rows will be different i want to create dynamic
range names
thanks
|