How to use arrays?

		Microsoft Office Forums > Microsoft Excel > Excel
How to use arrays?

FAQ

Thread Tools

Display Modes

09-03-2016, 02:32 AM

Simplifier Simplifier is offline

Windows 7 32bit How to use arrays?

Office 2010 32bit

Novice

Join Date: Sep 2016

Posts: 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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:32 AM.