Hi,
To work on different sheets you don't always need array formulas. It is
possible that you need nested formulas for your work. e.g.
If you click on a cell containing formula and see something like:
{=SUM(A1:B100)}
This is an array formula. It is identified by the curly bracket in formula
{ }. To enter formula as an array formula you type a formula and instead
of pressing enter you press Ctrl + Shift + Enter hence the name CSE
formulas.
If you click on a cell containing formula and see something like:
=IF(VLOOKUP(A1,$B$1:$D$100,3,0)3,SUM(A1:A3),A1)
This is a nested formula which contains many formulas nested inside one
another. Nesting one formula into another is often useful and in most of
the cases you use this only.
In case you need array functions for your work you can search Google for
array functions and you will find many tutorials on the topic.
Warm Regards,
Anand
On Wed, Apr 3, 2013 at 8:44 AM, Lalit Mohan Pandey mohan.pande...@gmail.com
wrote:
Just write your formula and comfirm it with CSE.
Or you can go through below link:
http://www.cpearson.com/excel/ArrayFormulas.aspx
http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
http://www.excelfox.com/forum/f2/count-consecutive-value-range-using-formula-391/
On Tuesday, 2 April 2013 22:33:07 UTC+5:30, kushy wrote:
I am using multiple sheets in a file. I want to know how to write array
formulas(those that are combination of formulas or have a lot of brackets).
any simple lead with basic formulas would be very fulfilling.
--
Regards Always,
Kushlesh Sharma
9907517169
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
MS EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Warm regards,
Anand Kumar
Data Analyst (Research)
Datamation CS
09990525998
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
