G
Guest
How to overcome the limit in choose function of 29 index no. I have got 31 days data to apply the choose function. I am just 2 no. short! Help!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy B
Hi
It depends on what you're trying to achieve. There is probably a better
way - maybe using a table and VLOOKUP or INDEX and MATCH
--
Andy.
It depends on what you're trying to achieve. There is probably a better
way - maybe using a table and VLOOKUP or INDEX and MATCH
--
Andy.
31 days data to apply the choose function. I am just 2 no. short! Help!Cheryl said:How to overcome the limit in choose function of 29 index no. I have got
F
Frank Kabel
Hi
use a lookup table and VLOOKUP (see:
http://www.mvps.org/dmcritchie/excel/vlookup.htm)
or provide some more detail about your current CHOOSE function There
may be other ways if you have a logic behind this selection
--
Regards
Frank Kabel
Frankfurt, Germany
Help!
use a lookup table and VLOOKUP (see:
http://www.mvps.org/dmcritchie/excel/vlookup.htm)
or provide some more detail about your current CHOOSE function There
may be other ways if you have a logic behind this selection
--
Regards
Frank Kabel
Frankfurt, Germany
got 31 days data to apply the choose function. I am just 2 no. short!Cheryl said:How to overcome the limit in choose function of 29 index no. I have
Help!
R
Ron Rosenfeld
How to overcome the limit in choose function of 29 index no. I have got 31 days data to apply the choose function. I am just 2 no. short! Help!
You cannot overcome that limitation in the CHOOSE function. You will need to
use a different method. If you post specifications, someone will be able to
help.
--ron