RE: $$Excel-Macros$$ Learn Array formula's

2012-10-15 Thread Anil Bhange
Try this

http://www.cpearson.com/excel/ArrayFormulas.aspx


Regards,Anil Bhange
IP Phone - 800105 | Mobile - +31 6 1192 3971

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Muralidhar E
Sent: Monday, October 15, 2012 01:39 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Learn Array formula's

good evening all members,

Expecting examples excel file, reg. Array formula functions.
I want to learn can anyone send me the array formula's guide for beginners with 
examples.
I want to know/learn the logic of Array formulas can u provide me the files 
with examples in excel. It will help me to learn very easily.

Hi,Noorain,
I expecting from your side, i may you will have the better examples to learn 
easily.
On Wed, Sep 5, 2012 at 4:02 PM, Muralidhar E 
emuralidha...@gmail.commailto:emuralidha...@gmail.com wrote:
hi,

Expecting examples excel file, reg. Array formula functions.



On Thu, Aug 30, 2012 at 5:58 PM, NOORAIN ANSARI 
noorain.ans...@gmail.commailto:noorain.ans...@gmail.com wrote:
Sure Murlidhar,

i will provide you shortly.

On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E 
emuralidha...@gmail.commailto:emuralidha...@gmail.com wrote:
Hi,
Thanks alot. If u give any files with examples in excel or in ppt. it will help 
me to learn very easily.

Thanks in advance.

Thanks
Muralidhar E
On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI 
noorain.ans...@gmail.commailto:noorain.ans...@gmail.com wrote:
Dear Murlidhar,

Some best sites for Array Function

http://www.cpearson.com/excel/ArrayFormulas.aspx
http://www.ozgrid.com/Excel/arrays.htm

On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E 
emuralidha...@gmail.commailto:emuralidha...@gmail.com wrote:
hi to all group members,

I want to learn can anyone send me the array formula's guide for beginners with 
examples.

Thanks in advance.
--
Thanks  Regards,

Muralidhar E.
Think different
Do Different
Make different

--
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.commailto:excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com.




--
With Regards,
Noorain Ansari
http://http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/
http://http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.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.commailto:excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com.





--
Thanks  Regards,

Muralidhar E.
Think different
Do Different
Make different

--
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

RE: $$Excel-Macros$$ Learn Array formula's

2012-10-15 Thread Anil Bhange
Find few more


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.ukhttp://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-formula/

* 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-array-formulas-HA010228458.aspx

* Putting basic array formulas to work -- John Walkenbach  
https://office.microsoft.com/en-us/excel-help/putting-basic-array-formulas-to-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/




Regards,Anil Bhange
IP Phone - 800105 | Mobile - +31 6 1192 3971

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Muralidhar E
Sent: Monday, October 15, 2012 01:39 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Learn Array formula's

good evening all members,

Expecting examples excel file, reg. Array formula functions.
I want to learn can anyone send me the array formula's guide for beginners with 
examples.
I want to know/learn the logic of Array formulas can u provide me the files 
with examples in excel. It will help me to learn very easily.

Hi,Noorain,
I expecting from your side, i may you will have the better examples to learn 
easily.
On Wed, Sep 5, 2012 at 4:02 PM, Muralidhar E 
emuralidha...@gmail.commailto:emuralidha...@gmail.com wrote:
hi,

Expecting examples excel file, reg. Array formula functions.



On Thu, Aug 30, 2012 at 5:58 PM, NOORAIN ANSARI 
noorain.ans...@gmail.commailto:noorain.ans...@gmail.com wrote:
Sure Murlidhar,

i will provide you shortly.

On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E 
emuralidha...@gmail.commailto:emuralidha...@gmail.com wrote:
Hi,
Thanks alot. If u give any files with examples in excel or in ppt. it will help 
me to learn very easily.

Thanks in advance.

Thanks
Muralidhar E
On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI 
noorain.ans...@gmail.commailto:noorain.ans...@gmail.com wrote:
Dear Murlidhar,

Some best sites for Array Function

http://www.cpearson.com/excel/ArrayFormulas.aspx
http://www.ozgrid.com/Excel/arrays.htm

On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E 
emuralidha...@gmail.commailto:emuralidha...@gmail.com wrote:
hi to all group members,

I want to learn can anyone send me the array formula's guide for beginners with 
examples.

Thanks in advance.
--
Thanks  Regards,

Muralidhar E.
Think different
Do Different
Make different

--
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

Re: $$Excel-Macros$$ Learn Array formula's

2012-09-05 Thread Muralidhar E
hi,

Expecting examples excel file, reg. Array formula functions.



On Thu, Aug 30, 2012 at 5:58 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Sure Murlidhar,

 i will provide you shortly.


 On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E emuralidha...@gmail.comwrote:

  Hi,
 Thanks alot. If u give any files with examples in excel or in ppt. it
 will help me to learn very easily.

 Thanks in advance.

 Thanks
 Muralidhar E

  On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.com wrote:

 Dear Murlidhar,

 Some best sites for Array Function

 http://www.cpearson.com/excel/ArrayFormulas.aspx
 http://www.ozgrid.com/Excel/arrays.htm


 On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E 
 emuralidha...@gmail.comwrote:

  hi to all group members,

 I want to learn can anyone send me the array formula's guide for
 beginners with examples.

 Thanks in advance.
 --
  *Thanks  Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

 --
 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.






 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/
 http:// 
 http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/


 --
 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.






 --
  *Thanks  Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

  --
 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.






 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/
 http:// 
 

Re: $$Excel-Macros$$ Learn Array formula's

2012-08-30 Thread Muralidhar E
Hi,
Thanks alot. If u give any files with examples in excel or in ppt. it will
help me to learn very easily.

Thanks in advance.

Thanks
Muralidhar E

On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Murlidhar,

 Some best sites for Array Function

 http://www.cpearson.com/excel/ArrayFormulas.aspx
 http://www.ozgrid.com/Excel/arrays.htm


 On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E emuralidha...@gmail.comwrote:

  hi to all group members,

 I want to learn can anyone send me the array formula's guide for
 beginners with examples.

 Thanks in advance.
 --
  *Thanks  Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

 --
 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.






 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/
 http:// 
 http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/


 --
 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.






-- 
 *Thanks  Regards,*
**
*Muralidhar E.*
Think different
Do Different
Make different

-- 
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.




Re: $$Excel-Macros$$ Learn Array formula's

2012-08-30 Thread noorain . ansari
Sure murli,

I will provide u shortly




Sent from BlackBerry® on Airtel

-Original Message-
From: Muralidhar E emuralidha...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Aug 2012 12:44:38 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Learn Array formula's

Hi,
Thanks alot. If u give any files with examples in excel or in ppt. it will
help me to learn very easily.

Thanks in advance.

Thanks
Muralidhar E

On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Murlidhar,

 Some best sites for Array Function

 http://www.cpearson.com/excel/ArrayFormulas.aspx
 http://www.ozgrid.com/Excel/arrays.htm


 On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E emuralidha...@gmail.comwrote:

  hi to all group members,

 I want to learn can anyone send me the array formula's guide for
 beginners with examples.

 Thanks in advance.
 --
  *Thanks  Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

 --
 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.






 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/
 http:// 
 http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/


 --
 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.






-- 
 *Thanks  Regards,*
**
*Muralidhar E.*
Think different
Do Different
Make different

-- 
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.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED

Re: $$Excel-Macros$$ Learn Array formula's

2012-08-30 Thread NOORAIN ANSARI
Sure Murlidhar,

i will provide you shortly.

On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E emuralidha...@gmail.comwrote:

 Hi,
 Thanks alot. If u give any files with examples in excel or in ppt. it will
 help me to learn very easily.

 Thanks in advance.

 Thanks
 Muralidhar E

 On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

 Dear Murlidhar,

 Some best sites for Array Function

 http://www.cpearson.com/excel/ArrayFormulas.aspx
 http://www.ozgrid.com/Excel/arrays.htm


 On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E emuralidha...@gmail.comwrote:

  hi to all group members,

 I want to learn can anyone send me the array formula's guide for
 beginners with examples.

 Thanks in advance.
 --
  *Thanks  Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

 --
 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.






 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/
 http:// 
 http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/


 --
 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.






 --
  *Thanks  Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

  --
 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.






-- 
With Regards,
Noorain Ansari
http:// 
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http:// 
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/

-- 
Join official facebook page of this forum @ 

$$Excel-Macros$$ Learn Array formula's

2012-08-29 Thread Muralidhar E
hi to all group members,

I want to learn can anyone send me the array formula's guide for beginners
with examples.

Thanks in advance.
-- 
 *Thanks  Regards,*
**
*Muralidhar E.*
Think different
Do Different
Make different

-- 
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.




Re: $$Excel-Macros$$ Learn Array formula's

2012-08-29 Thread NOORAIN ANSARI
Dear Murlidhar,

Some best sites for Array Function

http://www.cpearson.com/excel/ArrayFormulas.aspx
http://www.ozgrid.com/Excel/arrays.htm

On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E emuralidha...@gmail.comwrote:

 hi to all group members,

 I want to learn can anyone send me the array formula's guide for beginners
 with examples.

 Thanks in advance.
 --
  *Thanks  Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

  --
 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.






-- 
With Regards,
Noorain Ansari
http:// 
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http:// 
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/

-- 
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.