Re: $$Excel-Macros$$ Excel Formulas

2010-02-26 Thread ayush jain
Hi Putta,

Attached is updated sheet with formulas.

As I have already helped you earlier on same formulas, Please give a try
before you send request to group going forward.
This group is not formed to get your work done but to get technical
assistance only. I hope you understand.


Best regards,
Ayush Jain
Group Owner.

On Fri, Feb 26, 2010 at 7:59 PM, Putta Madaiah puttamada...@gmail.comwrote:

 Hi Ayush,

 I need another favour from you.

 Please check the attached sheet and provide me the formulas as required in
 the table.

 Rgds- Madaiah, Bangalore

 On Fri, Feb 5, 2010 at 8:47 PM, ayush jain jainayus...@gmail.com wrote:

 Hi Madajah,

 Attached is the updated solution with the new condition.

 Best regards,
 Ayush Jain
 Group Owner


 On Fri, Feb 5, 2010 at 5:43 PM, Putta Madaiah puttamada...@gmail.comwrote:

 Hi Ayush,

 Thanks for the formulas. It will be great also if you can consider only
 for N under column 'Doc Type'.

 Regards- Madaiah

   On Thu, Feb 4, 2010 at 8:19 PM, ayush jain jainayus...@gmail.comwrote:

 Hi Madaiah,

 Attached is the solution for you. I have used countifs formula for the
 solution.
 Let us know if any further assistance is required.

 Best regards,
 Ayush Jain


 On Thu, Feb 4, 2010 at 6:42 PM, Putta Madaiah 
 puttamada...@gmail.comwrote:

 Hi Group,

 Can anyone help me with the excel formulas for the fields coloured in
 yellow in the attached file.

 With Best Regards,
 Madaiah- Bangalore

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com
 
 HELP US GROW !!

 We reach over 6,700 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe








-- 
Best regards,
Ayush Jain

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Putta_Prob.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Excel Formulas

2010-02-05 Thread Putta Madaiah
Hi Ayush,

Thanks for the formulas. It will be great also if you can consider only for
N under column 'Doc Type'.

Regards- Madaiah

On Thu, Feb 4, 2010 at 8:19 PM, ayush jain jainayus...@gmail.com wrote:

 Hi Madaiah,

 Attached is the solution for you. I have used countifs formula for the
 solution.
 Let us know if any further assistance is required.

 Best regards,
 Ayush Jain


 On Thu, Feb 4, 2010 at 6:42 PM, Putta Madaiah puttamada...@gmail.comwrote:

 Hi Group,

 Can anyone help me with the excel formulas for the fields coloured in
 yellow in the attached file.

 With Best Regards,
 Madaiah- Bangalore

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com
 
 HELP US GROW !!

 We reach over 6,700 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe




-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com

HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Putta_M(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Excel Formulas

2010-02-05 Thread ayush jain
Hi Madajah,

Attached is the updated solution with the new condition.

Best regards,
Ayush Jain
Group Owner

On Fri, Feb 5, 2010 at 5:43 PM, Putta Madaiah puttamada...@gmail.comwrote:

 Hi Ayush,

 Thanks for the formulas. It will be great also if you can consider only for
 N under column 'Doc Type'.

 Regards- Madaiah

 On Thu, Feb 4, 2010 at 8:19 PM, ayush jain jainayus...@gmail.com wrote:

 Hi Madaiah,

 Attached is the solution for you. I have used countifs formula for the
 solution.
 Let us know if any further assistance is required.

 Best regards,
 Ayush Jain


 On Thu, Feb 4, 2010 at 6:42 PM, Putta Madaiah puttamada...@gmail.comwrote:

 Hi Group,

 Can anyone help me with the excel formulas for the fields coloured in
 yellow in the attached file.

 With Best Regards,
 Madaiah- Bangalore

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com
 
 HELP US GROW !!

 We reach over 6,700 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe





-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com

HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Putta_M.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet