Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Chandra Shekar
Thanks Vaibhav

On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by Bill
 Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.


Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Ganesh N
Hi Vaibhav Ji,

Can you please explain how the attachment works because I cant even see any
macro in that file.

Note: Its in the amazing excel formulas file.

Thanks  Regards,
Ganesh N

On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by Bill
 Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.


Page038_NatLang.xls
Description: MS-Excel spreadsheet


Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Vaibhav Joshi
Hi

There is no Macro in this file, it contains formula only.

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even see
 any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by Bill
 Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Ganesh N
Yes sir no macro but can you tell me how the formula works ?

e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount in
addition row/col it not working

Regards,
Ganesh N

On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even see
 any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Vaibhav Joshi
ok, COGS is named range, press Ctr + G you will see all defined cells.
Select COGS you will be taken to range.

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com wrote:

 Yes sir no macro but can you tell me how the formula works ?

 e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount
 in addition row/col it not working

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even see
 any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Ganesh N
Got it sir!! Thanks

One more help sir. Like formulas do you have sample files for macros ? just
to learn. im a beginner to macro.

Regards,
Ganesh N

On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi v...@vabs.in wrote:

 ok, COGS is named range, press Ctr + G you will see all defined cells.
 Select COGS you will be taken to range.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com wrote:

 Yes sir no macro but can you tell me how the formula works ?

 e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount
 in addition row/col it not working

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even see
 any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Prafull Jadhav
Dear Vaibhav Sir,

Thanks for the shared us a very useful file.


Regards,
Prafull Jadhav
9920553518

On 18 September 2014 17:32, Ganesh N ganeshg...@gmail.com wrote:

 Got it sir!! Thanks

 One more help sir. Like formulas do you have sample files for macros ?
 just to learn. im a beginner to macro.

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi v...@vabs.in wrote:

 ok, COGS is named range, press Ctr + G you will see all defined cells.
 Select COGS you will be taken to range.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com wrote:

 Yes sir no macro but can you tell me how the formula works ?

 e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount
 in addition row/col it not working

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even
 see any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Govardhan Bhatia
On 9/18/14, Prafull Jadhav prafulltjad...@gmail.com wrote:
 Dear Vaibhav Sir,

 Thanks for the shared us a very useful file.


 Regards,
 Prafull Jadhav
 9920553518

 On 18 September 2014 17:32, Ganesh N ganeshg...@gmail.com wrote:

 Got it sir!! Thanks

 One more help sir. Like formulas do you have sample files for macros ?
 just to learn. im a beginner to macro.

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi v...@vabs.in wrote:

 ok, COGS is named range, press Ctr + G you will see all defined cells.
 Select COGS you will be taken to range.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com wrote:

 Yes sir no macro but can you tell me how the formula works ?

 e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more
 amount
 in addition row/col it not working

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com
 wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even
 see any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for
 you.*

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Waseem Saifi
It is really an amazing collection vaibhav.
thank you so much vaibhav.

On Thu, Sep 18, 2014 at 8:06 AM, Govardhan Bhatia bkrishkr...@gmail.com
wrote:

 On 9/18/14, Prafull Jadhav prafulltjad...@gmail.com wrote:
  Dear Vaibhav Sir,
 
  Thanks for the shared us a very useful file.
 
 
  Regards,
  Prafull Jadhav
  9920553518
 
  On 18 September 2014 17:32, Ganesh N ganeshg...@gmail.com wrote:
 
  Got it sir!! Thanks
 
  One more help sir. Like formulas do you have sample files for macros ?
  just to learn. im a beginner to macro.
 
  Regards,
  Ganesh N
 
  On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi v...@vabs.in wrote:
 
  ok, COGS is named range, press Ctr + G you will see all defined cells.
  Select COGS you will be taken to range.
 
  Cheers!!
 
  +
  *I did not do this for you. God is here working through me for you.*
 
  On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com
 wrote:
 
  Yes sir no macro but can you tell me how the formula works ?
 
  e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more
  amount
  in addition row/col it not working
 
  Regards,
  Ganesh N
 
  On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:
 
  Hi
 
  There is no Macro in this file, it contains formula only.
 
  Cheers!!
 
  +
  *I did not do this for you. God is here working through me for you.*
 
  On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com
  wrote:
 
  Hi Vaibhav Ji,
 
  Can you please explain how the attachment works because I cant even
  see any macro in that file.
 
  Note: Its in the amazing excel formulas file.
 
  Thanks  Regards,
  Ganesh N
 
  On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
  chandrashekarb@gmail.com wrote:
 
  Thanks Vaibhav
 
  On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in
 wrote:
 
  Hi,
 
  No posts since morning thought of sharing amazing excel formulas
 by
  Bill Jelen aka Mr. Excel.
 
  Cheers!!
  +
  *I did not do this for you. God is here working through me for
  you.*
 
  --
  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.
  For more options, visit https://groups.google.com/d/optout.
 
 
   --
  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.
  For more options, visit https://groups.google.com/d/optout.
 
 
   --
  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 

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-17 Thread Sunil Kumar Yadav
really amazing!!!


*Thanks  Regards,Sunil Kumar Yadav*

On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by Bill
 Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.