Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHOOSE function - more than 29 items
Hi,
Is there a way of using the CHOOSE function if you have more than 29 values? AND Is there a way of avoiding typing in all of the 29 (or more) values into the formula box? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choose items from a list and add to a string in a cell | Excel Discussion (Misc queries) | |||
How can 0 be used in the Choose function | Excel Worksheet Functions | |||
Which function to choose? | Excel Worksheet Functions | |||
How do I choose multiple items from a drop down box? | Excel Worksheet Functions | |||
How do I compare two lists and choose the items that are in both? | Excel Worksheet Functions |