How to use arrays?
Hello. I have computed value and want to display some description about it. There are a few values possible. Array sound good, but I don't know about arrays in Excel. I tried:
=INDEX({"a";"b";"c"};0;2)
Should give me c, but throws address error.
BTW: Different languages version have localized function names. Is possible change it? For example to use only English names?
|