• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Fulfill the condition through a single formula

    Hello everyone, Thanks in advance. Attached please find the file and I cant solve this matter. Please help me. Best regards,
  2. M

    Count number of Schools having Student Teacher ratio more than 30

    Thank you so much sir, it is working fine.
  3. M

    Schools having student classroom ratio more than 30

    Hello everyone, Please help me. Attached please find the file. Regards,
  4. M

    Count number of Schools having Student Teacher ratio more than 30

    @ Somendra Misra Could you please solve it..... I am attached the file.
  5. M

    Count number of Schools having Student Teacher ratio more than 30

    Thank you so much Somendra and Abhijeet, Till now it is working fine, but I am preparing a dashboard and have almost 98000 schools. If I find any problem will get back to the forum. Best regards,
  6. M

    Count number of Schools having Student Teacher ratio more than 30

    Hello Somendra, The file is attached. Best regards,
  7. M

    Count number of Schools having Student Teacher ratio more than 30

    Hello Everyone, schcd schcat Nteacher Tstudent 19012903901 1 2 44 19012904001 3 5 95 19012904003 1 1 45 19012904101 1 5 67 19012904102 2 2 34 19012904201 2 3 49 19012904301 3 4 37 19012904401 1 0 39 19012904501 5 20 714 19012904502 4 2 54 19012904503 1 2 34 19012904601 4 4 124...
  8. M

    Dynamic chart automatically changing its range if we select wrong date

    Dear Smallman, This file is not the previous one. This is new file. The problem is if we select the month or year and if that particular month and date is not in our raw data range, chart showing no data, blank. Fine, no problem. But the chart format is changed and again I have to go to the...
  9. M

    Dynamic chart automatically changing its range if we select wrong date

    I have prepared a dynamic chart, we can select month, year and sales person. The chart is automatically generated monthly sales done by the sales persons . The starting date is 7-Apr-12 and end date is 31-Mar-13. The problem is that if we put the month and date not in our date range, the...
  10. M

    Sum up Sales Amount Occurred in Same Date under A Sales Person

    Hi Smallman, Thank you so much. Would you please send it through email to maniknandi [at] gmail [dot] com Thanks, Manik
  11. M

    Sum up Sales Amount Occurred in Same Date under A Sales Person

    Dear Smallman, Please find the file. https://www.dropbox.com/s/jts27btd9go8xds/Sales%20Analysis%20Database.xlsx Manik
  12. M

    Sum up Sales Amount Occurred in Same Date under A Sales Person

    Sorry Smallman, I did not understand. I thought you have sent any dashboard for example. Well my dashboard is under preparation and I did not use any pivot table there. Although frankly speaking I do not like to use pivot table, I love formulas. Thanks, Manik
  13. M

    Sum up Sales Amount Occurred in Same Date under A Sales Person

    Where is the dashboard?
  14. M

    Sum up Sales Amount Occurred in Same Date under A Sales Person

    Dear Smallman, The main reason is I want to use this formula in my dashboard. It should be dynamic, Yes I like to use formula instead of pivot table. Thanks, Manik
  15. M

    Sum up Sales Amount Occurred in Same Date under A Sales Person

    Dear Smallman, I want to add another request with my original request. I want to select a Sales Person in this case "A", the excel will extract an unique list of dates against "A" from my raw data and sum up amounts if sales has been made more than one time in that particular day. Similarly if...
  16. M

    Sum up Sales Amount Occurred in Same Date under A Sales Person

    Thanks everyone, I can use Pivot Table or Auto Filter that can solve my problem but I want to do it through formula only. Thanks,
  17. M

    Sum up Sales Amount Occurred in Same Date under A Sales Person

    Thanks Smallman. Please let me know how can I extract an unique list of Dates? Manik
  18. M

    Sum up Sales Amount Occurred in Same Date under A Sales Person

    I have a sales Database as under: Date SalesPerson Vendor SalesAmount 4/1/13 A XYZ Ltd. 4500 4/3/13 B AAA Ltd. 3000 4/3/13 B BBB Ltd. 3000 5/3/13 A BBB Ltd. 2500 6/1/13 B AAA Ltd. 5000 I want to extract data from the above database based on the...
  19. M

    Dynamic Formula Extract Data with more than one criteria

    Hi, Kaushik03, I want to know a dynamic formula that extract data from a Data Table with some criteria. Lets see the table below : Project Name Work in Progress Completed Gayeshpur 260 200 Kumartuli 90 325 Barrackpore 0 136 I want extract the...
  20. M

    Dynamic Formula Extract Data with more than one criteria

    Please let me know the Dynamic Formula which can Extract Data from a list with more than one criteria.
View older results
Back
Top