#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Hi
are you seem to be using European separators you should use the backslash as separator in arrays {"a"\"b"\"c"} OTH what are you trying to do? I don't think INDEX works on arrays
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy data btw worksheets using public arrays | OldColdDreamer | Excel Programming | 4 | 02-10-2016 09:56 AM |
Create an input box for arrays | rajani | Word VBA | 2 | 08-17-2015 06:28 AM |
Variable arrays from user input | SeattleITguy | Excel Programming | 1 | 01-29-2015 09:19 AM |
Searching Arrays without Loops? | ptmuldoon | Word VBA | 3 | 12-13-2014 11:21 AM |
re-naming arrays in VBA? | JDevsFan | Excel Programming | 4 | 03-15-2012 08:44 AM |