Recent content by vaidmohammed

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

Anyone can please help me.

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

Thank you, Experts and Camps, but I can't use Pivot in my report. I have to stick with VLOOKUP, as a change in the report means loads of work to be redone. Making my case very simple, I am attaching new workbook where : Worksheet DelvStatus: Contains delivery details, from where I am picking...

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

Thanks GraH but it doesn't helps. I need a formula which will search for the workbook at the defined location and then read worksheet name and get me the countifs of a particular column. In my shared sample file, I wish to have a formula which will search for the Sample workbook at the defined...

Please advice how to use this option. I will check today itself.

Yes I am using Ms Office 2016

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 tried using advised formula in my actual sheet but unable to get expected results. (I changed cell references and ranges accordingly) Attached is the one file, where I want it working. The actual file expectations : I need this formula to work in attached excel's PPM sheet in row no. 3...