Choose Function
 

I need to find a way to either

a) extend the choose function to handle more than 29 values or

B) change the index number so that it would read, for example, 30-59
instead of 1-29

any help would be apprieciated as I want to have a worksheet or a
series of worksheets that would have approx 170 colums of information
that would move beside the headings by entering a # therefore making it
easier to read.

Thanx


--
UD 9
------------------------------------------------------------------------
UD 9's Profile: http://www.excelforum.com/member.php...o&userid=29104
View this thread: http://www.excelforum.com/showthread...hreadid=488269

Choose Function
 

=CHOOSE(A1-29,.................

Or look at the INDEX() function in HELP

--
Kind regards,

Niek Otten

"UD 9" wrote in message
...

I need to find a way to either

a) extend the choose function to handle more than 29 values or

B) change the index number so that it would read, for example, 30-59
instead of 1-29

any help would be apprieciated as I want to have a worksheet or a
series of worksheets that would have approx 170 colums of information
that would move beside the headings by entering a # therefore making it
easier to read.

Thanx


--
UD 9
------------------------------------------------------------------------
UD 9's Profile:
http://www.excelforum.com/member.php...o&userid=29104
View this thread: http://www.excelforum.com/showthread...hreadid=488269