software

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--
deepthink
------------------------------------------------------------------------
deepthink's Profile: www.excelforum.com/member.php...oamp;userid=32467
View this thread: www.excelforum.com/showthread...hreadid=522549deepthink

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
Thanks Kostis Vezerides--
deepthink
------------------------------------------------------------------------
deepthink's Profile: www.excelforum.com/member.php...oamp;userid=32467
View this thread: www.excelforum.com/showthread...hreadid=522549