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.
