Search results

Hi, I have an excel where i have to maintain month wise budget amount utilized and also need to keep a track of percentage of budget utilized. I tried concatenate function, but it didn't work. Can you please advise me a formula to derive the values as shown in attached excel Row# 4 (this is how...

Hi, Attached is my budget allocation sheet. I am facing a problem in deriving a formula for getting the utilized amount. There are 4 worksheets : Costs --> Here my Associate's list and their designations are mentioned, under columns A to C. As well as designation wise per day cost is also...

Hi, Attached is an excel where few common details are mentioned in Col. A and in Col. B corresponding dates are mentioned. I need a formula in Col. E1 that, if I input any value of Col. A in Col. D1 then the system should show the max. date in Col E1. I tried the following formula but it is...

Hi, I use to get a report from our Testers who use to rename their Test Results excel with the current date. The problem is I have created another excel for getting a summary of status with the help of excel formulae. Since i use to get this Test execution report daily with the different naming...

Attached is the sheet where under Col A I have mentioned complete path of Excel workbook which I am referring in my formula from Col B to Col F. In the current set of formulae I have mentioned excel workbook name explicitly but I want that instead of mentioning workbook name in formulae I...

I need help on a formula creation for generation of a test execution report. My need is : Background 1. I use to get test status reports, in defined excel format on mails, from various team members who are geographically divided, on daily basis. 2. I use to maintain these reports in 1 folder 3...

Hi, I need your experts help to generate a combo chart in Excel. Below are the details, please help me with your expert advises. Attached is my data. Column A = Client Names Column B - D = No. of Production defects found in last 3 months. Column E - G = No. of UAT defects found in last 3...

I am having 2 formulae for deriving UAT and Production defects... following they are : FOR UAT :: =COUNTIFS(Data!$B$2:$B$50000,"Defect",Data!$D$2:$D$50000,"UAT",Data!$E$2:$E$50000,$A2,Data!$F$2:$F$50000,"Y") say the answer come as 121 FOR PRODUCTION ...

Hi, Attached is an excel where I have shared some data (Data worksheet) and have created 2 Pivot tables (Report worksheet). 1 is columnar pivot chart (issues reported) and another one is line pivot chart (issues closed). I want a single chart showing both pivots data. ie. a single pivot chart...

Hi, I want a formula where I can get COUNT of specified range for the dates range define by me. 01-Jan-17 A 02-Jan-17 B 03-Jan-17 C 04-Jan-17 D 05-Jan-17 E From To 01-Jan-17 03-Jan-17 04-Jan-17 05-Jan-17 I need a formula which gives me value 3...

I need help on Sumproduct formula for my attached data. Here I am having Items and SalesNames and their monthly sales columnwise. I am trying to work out a formula, using SUMPRODUCT, that the result should reflect in D12 after considering conditions mentioned in A, B, C 12 cell values. These all...

Hi, I am preparing an excel and need a formula on conditonal sum. The requirement is : In attached excel sheet, blue cells I need uniform sum formula which should be the sum of all values in column B between two 2500 values of column A. Eg.... In C4 the value should be 1000 (100+200+300+400)...

I am using ROMAN() formula in one of my formula. While converting number 4000 into ROMAN MS Excel 2013 is giving #VALUE! The formula which I am using is : - =CONCATENATE((ROMAN(COUNTA($P$6 : P4005)))," - ",P4005) Till 3999 it is working fine and giving roman number but from 4000 it is giving...

How to use OR function in COUNTIFS. I am trying to use OR function in criteria but it is not working. =COUNTIFS(A2:A10,(OR("PS","LA")),B2:B10,C2) This formula I am trying to use to extract information about how many observations have been identified by my resources PS and LA. Please help.

I have prepared an excel which contains tick by tick share market data i.e. trade volume and cumulative volume at exchange at each second of trading hours. I need volume data for the time period of 09:30:00 to 14:00:00. I have applied formula of VLOOKUP which gives me the most accurate...

Hello, I am having an excel, attached. In this the : First page is the Dashboard, which gives the statistics of results. Second page contins results for Access functionality. Third page contins results for Orders functionality. The cycle 1 results are defined under column head "ActRes_C1"...

I am having a very big excel work book, which contains more than 50 worksheets. I need a formula which list down the name of all worksheet in the workbook.

I am having an excel sheet with Index. INDEX Pass Failed Order Entry 50 60 Report 70 80 The workbook contains functionality wise test cases in different sheets. The Index contains the name of...

I am preparing a report with numbering in MS Excel 2010. URGENT In cell A1 the value is 1.1 and in A2 value is 1.2. Now from A4 I am describing the details thus, needs formula which automatically numbers it to 1.1.1, 1.1.2, 1.1.3 and so on. xxxxxxxxxxxxxxxxxxxxxxx.

Hello, I am having an excel file which records daily progress of test cases execution row-wise. The report is divided into 2 sections. 1st section gives the details of todays counts and the next section gives the historical dates status. This all is done manually. I wanted to write a macro...