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.com>wrote: > 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.com>wrote: >> >>> 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.com>wrote: >>>> >>>>> 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