• 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. K

    Conditional data population based on multiple date columns

    Hi Team, Greetings! Need your help on issue i am facing - Information: Have 6 Date columns (Date1 to Date6) and 2 resulting columns as "12M" & "36M" which are dependent on these 6 date columns. Problem Statement: If any of 4 Dates columns out of 6 are less than a Years duration then "12M"...
  2. K

    Monthly Tracking Dashboard for Engagement

    Hi There, Greetings! I am looking for monthly dashboard to track the engagements/opportunities. Problem Statement - Need a monthly dashboard with below requirements - Current State wise data DM wise data Current State & Last Month State comparison (Not sure how to derive Last month state...
  3. K

    Facing challenges in Tax Calculation sheet

    Hi, I am preparing a sheet for tax calculation at an organization level (Same is attached herewith). Here i am facing some challenges which are mentioned below. Data - There are two sheets - 1) Sheet1 - Output with all data points 2) Sheet2 - Input sheet Problem Statement - For an EMP...
  4. K

    Need Unique count of values based on two columns criterias

    Hi, I have a set of data records in excel sheet. I want to display unique count of employees per department. E.g. - In Dept1, if there are 3 entries for Resoruce1 then i want to show only 1 and not 3. Attached herewith is the sample data. Looking forward for help. Thanks. Regards, Krishna
  5. K

    Generating report based on multiple dropdown selection

    As a Sr. Manager, want to create a report with 3 main filter criteria’s as – Client Group, Project Name and Delivery Manager. Whenever any manager selects values from these dropdowns, tabular report should get generated in report sheet from the BASEDATA Available data - · Basedata for...
  6. K

    Auto complete string or number

    Hi, Greetings there! Trying to create an application in excel VBA for maintaining few basic employee data points. Stuck somewhere and need help. Problem Statement - Have EmpID, EmpName and Department as the textbox fields in form. Whenever any employee start key-in his EmpID in id textbox...
  7. K

    Best way to present Yearly/Quarterly trend (data captured week on week) in graph

    Hello Everyone! I have 3 quarters data for 2011 and 1 quarter data for 2012 captured in week patern. i want to analyze this whole data in one go just like a trend for all instances till now. can someone please help me out in acheiving the same? i tried something which was very basic and...
Back
Top