I don't know the book, but here it is. Rajan had a small typo in the author's name, perhaps that was the difficulty:
http://www.amazon.com/Microsoft-Functions-Formulas-Edition-Computer/dp/19364 20015/ref=pd_bxgy_b_text_y/185-8930763-6171505 Or the downloadable Kindle Edition: http://www.amazon.com/Microsoft-EXCEL-Functions-Formulas-ebook/dp/B005F5CR1K /ref=kinw_dp_ke Google is selling an ebook of the first edition (2007) at https://play.google.com/store/books/details/Bernd_Held_Microsoft_Excel_Funct ions_Formulas?id=8eNji8NTudAC <https://play.google.com/store/books/details/Bernd_Held_Microsoft_Excel_Func tions_Formulas?id=8eNji8NTudAC&feature=search_result#?t=W251bGwsMSwxLDEsImJv b2stOGVOamk4TlR1ZEFDIl0> &feature=search_result#?t=W251bGwsMSwxLDEsImJvb2stOGVOamk4TlR1ZEFDIl0 for a lower price. Here are links to some online tutorials: . Array Formulas by Chip Pearson http://www.cpearson.com/excel/ArrayFormulas.aspx . Introduction to Array Formulas by Colin Legg. (His website www.colinlegg.co.uk may have an updated vesion but seems to be down at the moment.) http://www.xtremevbtalk.com/showthread.php?t=296012 . Array Formulae -- Charles Williams (Decision Models) http://www.decisionmodels.com/optspeedj.htm . An introduction to array formulas -- Tushar Mehta http://www.tushar-mehta.com/publish_train/xl_vba_cases/array_formulas.htm . Multiple Condition Tests -- Bob Phillips (xlDynamic) http://www.xldynamic.com/source/xld.SUMPRODUCT.html . How SUMPRODUCT and differential rates work -- John McGimpsey http://www.mcgimpsey.com/excel/variablerate1.html . Using Array Formulas in Excel -- Bob Umlas http://www.emailoffice.com/excel/arrays-bobumlas.html . What are Array Formulas? -- Ozgrid http://www.ozgrid.com/Excel/arrays.htm . Anatomy of an Array Formula -- Dick Kusleika http://www.dailydoseofexcel.com/archives/2004/04/05/anatomy-of-an-array-form ula/ . Introducing array formulas in Excel -- Colin Wilcox and John Walkenbach https://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in- excel-HA001087290.aspx . Guidelines and examples of array formulas -- Colin Wilcox and John Walkenbach https://office.microsoft.com/en-us/excel-help/guidelines-and-examples-of-arr ay-formulas-HA010228458.aspx . Putting basic array formulas to work -- John Walkenbach https://office.microsoft.com/en-us/excel-help/putting-basic-array-formulas-t o-work-HA001087292.aspx . When to use a SUM(IF()) array formula -- Microsoft http://support.microsoft.com/kb/275165 . thoughts: Ignorance - an excellent starting point for learning -- Jan Nordgreen (Mum). Details a problem and how it was solved, step-by-step, for weighted-average test scores. http://mumnet.easyquestion.net/thoughts/ignorance.htm . A quick introduction to arrays and array formulas -- Larry Blaisdell http://www.uninets.net/~blaisdel/Excel_Array.htm . Excel Array Formula -- Linda Treacy http://www.myonlinetraininghub.com/excel-array-formula . All articles with 'array formulas' Tag -- Chandoo http://chandoo.org/wp/tag/array-formulas/ Asa -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of maksood alam Sent: Saturday, September 08, 2012 3:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ I want to Learn Array Formulas don don don, i did't find it thats why am asking, why u take all the thing in wrong way. On 9/7/12, dguillett1 < <mailto:dguille...@gmail.com> dguille...@gmail.com> wrote: > Is there some reason you cannot "google" it yourself???? > > Don Guillett > Microsoft Excel Developer > SalesAid Software > <mailto:dguille...@gmail.com> dguille...@gmail.com > > From: maksood alam > Sent: Friday, September 07, 2012 12:50 PM > To: <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ I want to Learn Array Formulas > > Hi Rajan > > Please provide the link to download > Excel function and formulas by Berend held > > > > > On Fri, Sep 7, 2012 at 7:24 PM, Rajan_Verma < <mailto:rajanverma1...@gmail.com> rajanverma1...@gmail.com> > wrote: > > Google and Download this book > > > > Excel function and formulas by Berend held > > > > > > Regards > > Rajan verma > > +91 7838100659 [IM-Gtalk] > > > > From: <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com [ <mailto:excel-macros@googlegroups.com> mailto:excel-macros@googlegroups.com] > On Behalf Of Waseem Saifi > Sent: 07 September 2012 2:59 > To: <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ I want to Learn Array Formulas > > > > Hi All Members, > > I want to learn array formulas in excel 2007. > > Please send me some useful stuff or refer me any useful link to learn > array formulas. > > thanx in advance. > > > > Regards, > > Waseem Saifi > > -- > Join official facebook page of this forum @ > <https://www.facebook.com/discussexcel> https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > <mailto:excel-macros+unsubscr...@googlegroups.com> excel-macros+unsubscr...@googlegroups.com. > > > > -- > Join official facebook page of this forum @ > <https://www.facebook.com/discussexcel> https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > <mailto:excel-macros%2bunsubscr...@googlegroups.com> mailto:excel-macros%2bunsubscr...@googlegroups.com. > > > > > -- > Join official facebook page of this forum @ > <https://www.facebook.com/discussexcel> https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > <mailto:excel-macros+unsubscr...@googlegroups.com> excel-macros+unsubscr...@googlegroups.com. > > > > -- > Join official facebook page of this forum @ > <https://www.facebook.com/discussexcel> https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > <mailto:excel-macros+unsubscr...@googlegroups.com> excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ <https://www.facebook.com/discussexcel> https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com. To unsubscribe from this group, send email to <mailto:excel-macros+unsubscr...@googlegroups.com> excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
