Saturday, May 17, 2008 Join | Login | Why Join?
Office Users - Help with Office applications.  

 
Search:  

Quick Login
User name/Email:

Password:

 
HOME

Topic Areas
Access
Excel
General Info
PowerPoint
Word
 
OFFICEtv
Office Users TV
Upcoming
On-Demand Viewing
Downloadable
 
OFFICERadio Shows
Listen Now
Directory of Shows
 
Most Popular Searches
excel
access
PowerPoint
word
vista
 
Site Tools
RSS/XML Feeds
Newsletter Archives
Employers: Post Jobs
Find a Job
 
Resources
White Paper Library
Product Directory
FAQ System
Forums
 
About OfficeUsers.ORG
About OfficeUsers
Write for OfficeUsers
Request Product Review
Advertise on OfficeUsers.ORG
Contact Us
 
Other Resources
SSWUG.Org
MS SQL City
 
...for instant access to articles, tips, discussion groups and more. It takes less than 60 seconds.
Access to 178 free guest articles, discussions and more, just create your free OfficeUsers User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Available to Members = Members-Only     Available to Registered Guests = Registered Guests.


Available to MembersDo You Know What An Array Formula Is?
 Article Abstract:

Array Formula is an excel feature which is the ability to do multi calculation and give single or multiple results. Array Formula works on two or more data ranges which consist of arguments. The argument of array should have same number of rows/columns. Creating array formula is same as creating regular formula but we have to end it by clicking CTRL+SHIFT+ENTER (CSE).

 Read this article...
 Related Articles - For Members.
All Articles By Author

Formulas Don't Calculate as Formulas
Excel Custom Functions/Formulas - Excel User Defined Functions/Formulas
Lookup Tables
PowerPoint and Excel Worksheets
Excel Vlookup formula-function explained
Array-Entered Formulas in Excel
Excel Fill Handle Explained
Masking Social Security Numbers in an Excel Worksheet
Microsoft Excel Formula and VBA Macro Code To Fill All Blank Cells In a List
Excel Security and Excel Password Protection

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati


Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content
No Comments/Feedback Posted Yet. Post Your Comments/Feedback
   



 
 
[ Register ] [ Webcasts ] [ Podcasts ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to OfficeUsers ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (486)

Some names and products covered by OfficeUsers are the registered trademarks of their respective owners.