Search results

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

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

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

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

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

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

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

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

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.

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

Thanks for the explanation.

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?

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))

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

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

I have assigned codes to some items such as 01 Item A 02 Item B This information is in different columns. I have combined this information and assigned it as a list for data validation for a cell. What I want is after I select an entry in the data validation list, I only want the item...