Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-03-2016, 02:32 AM
Simplifier Simplifier is offline How to use arrays? Windows 7 32bit How to use arrays? Office 2010 32bit
Novice
How to use arrays?
 
Join Date: Sep 2016
Posts: 1
Simplifier is on a distinguished road
Question 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?
Reply With Quote
  #2  
Old 09-03-2016, 03:50 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to use arrays? Windows 7 64bit How to use arrays? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use arrays? 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
How to use arrays? Searching Arrays without Loops? ptmuldoon Word VBA 3 12-13-2014 11:21 AM
How to use arrays? 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 06:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft