Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to test compound Array Formula strings for correctness.

Posted on 2014-07-21
3
Medium Priority
?
157 Views
Last Modified: 2014-07-21
When constructing fairly hefty compound Array Formulae, what is the best way of testing them for syntactical correctness (braces, etc) before they get added to the code and cause errors? I know I can put them back into Excel directly in some cell so as the parser can take a look at typos, but is there a better way? Thanks all.
0
Comment
Question by:krakatoa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 2000 total points
ID: 40208572
That's the best and easiest way I know of.
0
 
LVL 16

Author Comment

by:krakatoa
ID: 40208579
Ah, right.

Do you happen to know what type of typos  - if any - that it isn't able to spot?
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 40208654
It will catch all syntax errors, but not typos in named ranges etc. unless you type it in the cell instead of pasting it, in which case it should catch everything.
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question