Sub range from a range

D

deepthink

Hi all

I have a dynamic named range that is based on an offset formula. Say
that it currently references to A11:C50. How would a formula that
selects everything except the first column from that range (B11:C50)
look?

Thanks
 
V

vezerid

deepthink

this expression will return a reference to a subrange of _range_
according to your specifications:

OFFSET(_range_,0,1,,COLUMNS(_range_)-1)

HTH
Kostis Vezerides
 
Top