• 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

    How can we extract data from a custom no formatted dataset?

    Hello All, We have a dataset, contains numeric figures are custom formatted as Debit "Dr" and Credit "Cr". We want to extract/ filter that numbers as Dr or Cr. Kindly help us. Thanks in advance.
  2. M

    Extract data date wise from a table

    Looking for formula to extract date wise values from the table to a new table. Sample file is attached. Thanks.
  3. M

    Extract data based on criteria

    Hello Everyone, I want to extract data from a table, Where I select an item, it will extract the available place and amount. Attached kindly find the file. Many many thanks in advance.
  4. M

    Want to Change Mouse Cursor

    Hello, I want to change the mouse pointer from (plus sign to arrow or something) in excel through VBA. I have a range of cells data and each cell is hyperlinked through VBA. But the cursor point is plus sign which I want to change and can understand the data is hyperlinked. Please help me and...
  5. M

    Hyperlink to same worksheet for different project

    Dear Sir, Greetings! Kindly help us regarding hyperlink while selecting a project name in the worksheet it will open in other worksheet and show the details of that project. Example : We have a workbook which contain the name and detail of projects. In a worksheet, we can sort through...
  6. M

    If and date function

    Sir Attached please find the file and Thanks in advance.
  7. M

    sort ascending order value and find adjacent cell value

    Thanks in advance.
  8. M

    Nested if function

    Attached please find. Thanks in advance.
  9. M

    Extract cost based on criteria

    Attached please find and help me. Thanks in advance.
  10. M

    count and sum up

    I have a database like this: City Project Status Amount A Project A Open 3419 A Project B Closed 5407 B Project C Progress 2351 A Project D Closed 2185 B Project E Open 5501 my requirement is like this: In a data validation under City 3 option A, B and "All". If I select Äll, it will count...
  11. 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,
  12. M

    Schools having student classroom ratio more than 30

    Hello everyone, Please help me. Attached please find the file. Regards,
  13. 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...
  14. 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...
  15. 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...
  16. 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.
Back
Top