Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto average function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Custom Function | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
CHOOSE Function | Excel Worksheet Functions |