Choose Function

  • Thread starter Thread starter UD 9
  • Start date Start date
U

UD 9

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
 
=CHOOSE(A1-29,.................

Or look at the INDEX() function in HELP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top