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

Recent content by AK

  1. A

    Chart to depict effective life of software

    Hello I want to prepare a chart showing the effective life of a software. e.g. I have the following table: Name of Software Version Introduced EOL SoftwareA 1.0 March 2009 June 2011 SoftwareA 2.0 January 2011 December 2015 SoftwareB 6.1...
  2. A

    Display tasks worked on between any 2 dates

    Hello Hui Why have you used the '+' sign before the 'RANK' formula? Thanks and Regards AK
  3. A

    Display tasks worked on between any 2 dates

    Hello Hui Thanks a lot for the help. You solved my problem. Also I learnt another use of RANK. Thanks you very much. Regards AK
  4. A

    Display tasks worked on between any 2 dates

    Hello I have to prepare a report on the tasks that were worked on between 2 dates. The data that I have is a set of tasks alongwith their start and end dates e.g. Task Start date End date Task1 15-Jan-2010 28-Jan-2010 Task2 20-Jan-2010 24-Jan-2010 ... The report...
  5. A

    Display argument values when calling a subroutine in VBA

    I am writing a macro and calling another subroutine from within that macro. The subroutine has around 3 arguments which are integers. The values of the arguments can only be between 1 and 4, each integer denoting a specific case which is handled in the subroutine. While i am typing to call the...
  6. A

    Calculated field in Pivot

    Thanks for your example. However, it did not solve the purpose. I fixed the problem with the help of a macro. Thanks for your help. AK
  7. A

    Calculated field in Pivot

    Hello Let me explain further. The pivot is giving me the data in the form I want. What I want additional is one more row in the pivot which will be a %age of the the total deptwise numbers. I can upload my example to clarify if needed. Please let me know how do I upload it. Thanks AK
  8. A

    Calculated field in Pivot

    I have data in tabular format as follows: Requirement Type Dept1 Dept2 Dept3 Total Req1 Type1 10 29 30 69 Req2 Type2 20 29 30 79 Req3 Type3 5 29 30 65 What is needed is the number which is a %age of...
  9. A

    Unique values from an unsorted column meeting a certain criteria

    Hello Hui I do not want any manual step. I want to use formulae so that any change/update to the List automatically updates the derived list.
  10. A

    Unique values from an unsorted column meeting a certain criteria

    Hello I need to derive sorted unique values from column. For the purpose I use the following formula from cell A3 below onwards entered as an array formula: INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF(A$2:$A2, List))*(COUNTIF(List, ">"&List)+1))=(COUNTIF(List, ">"&List)+1), 0, 1), 0))...
  11. A

    Usage of 2 hyphens in formula

    Thanks for the explanation.
  12. A

    Populating cells based on another value

    I have the following table Item1 4 Item2 2 Based on this data, i want to populate cells in 6 rows (4 + 2) as follows: Item1 Item1 Item1 Item1 Item2 Item2 This is because Item1 has a corresponding value of 4 and Item2 of 2 in the table above. Can this be done without using VBA?
  13. A

    Usage of 2 hyphens in formula

    Why and how are 2 consecutive hyphens used in an Excel formula? e.g. what is the meaning of =sumproduct(--(a1:a4="x"),(b1:b4))
  14. A

    Logical condition in IF statement

    Thanks for the explanations. What I had put forth was just an example, sorry for the confusion it caused. In reality I wanted to do this concatenate(A2," - ", b2, " - ", c2) where a2, b2 and c2 are strings. If c2 is empty then the resultant string will have an hyphen at the end, which I...
  15. A

    Logical condition in IF statement

    Is there any easy way to write a formula which will do the following: =if(concatenate(a2*b2-c2+d2*e2)="",NA,concatenate(a2*b2-c2+d2*e2)) The reason is if there is complex calculation, then the 'if' statement becomes too long and also changes have to be done at 2 places. Regards AK
Top