Thread: CHOOSE function - more than 29 items
View Single Post
  #1  
Old June 2nd, 2010, 06:47 PM posted to microsoft.public.excel.worksheet.functions
Amanda
external usenet poster
  
Posts: 335
Default 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