Search results

Hi Narayan Thank you very much for your time. I will go through the file and will test check with the live data. If I see any new issues, I will reach out to you. Thanks again for the timely help Regards

Hi Narayan and all the Ninjas, In my last reply I have explained all the 7 conditions that will be considered in analyzing the variance in revenue between 2 financial years. The comparison is primarily between the 2016 and 2017. In some conditions, the review of 2015 is required. Answering...

Hi, Kindly help with one if formula in the attached sheet Column E, F & G are different years revenue and Column H is the difference , which explains whether revenue has increased or decreased in 2017 when compared to 2016 & 2015 . We are trying to classify the revenue difference by comparing 3...

Thank you

Hi, I have attached an excel file which has 2 sheets ;Overview and data. Data has details of collections received at different collection centers. Collection mode is either cash or cheque. Overview sheet shows the desired expected output. User should be able to select all the 3 options i.e...

Hi Nebu, Firstly,thank you very much for the quick reply. How do I link the pivot as the output format cannot be changed. Once I refresh the pivot , the output should also automatically change. Hope you will help. Thanks

Hi, I kindly request help. In the attached file there are 2 sheets. Data and output. Data has customer performance details for different months. Customer details has different shipment files for which revenue , cost , margin and the related statistics are captured. Each of the shipment relates...

Dear Faseeh & Narayan Thank you very much. It looks good . I will now use the formula and will revert back if I need any issues. One more request : The default currency is QAR . If any other currency is selected it has to convert the figures in the output sheet. Is this possible ? For Eg : If...

Hi In the attached file you will find 2 sheets; 1. data sheet tab : this contains all the data which is derived from various sheets 2. Output per function : This is the output tab where I require help. There are different functions and the Profit and loss statement has to be produced...

Dear Nebu, I selected only 001.2015 , for both start and end date,but it displayed 002.2015 as well. There is a possibility that the user will select 001.2015 as both start and end date. This happens if he wants to review only one month. Can you please help Regards, Vishwas

Hi Nebu, Can you guide me how to do this please Thanks Vishwas

Dear Nebu - You are a star!!. Thank you. I will work on this for the moment and should I experience any more issues wherin I need help I will post it back in the forum as I new post. The only missing part in the layout is Year to date is missing. For example if the month selected is Jan &...

Hi Nebu, I think I may not have explained clearly. The budget data is fixed. This will not change. In the actual, there may be additional items during the month or less. My variance tab will include all the items i.e From Budget + additional items from Actual. I will be manually keying in...

Hi Nebu, In the budget and Actual tabs the headers will remain the same, however the items may or may not be present. Its a dump file extract. For example : In the budget tab ,Item salaries may be 200000 for Jan2015, but during the month there are no entries for salaries, hence in the Actuals...

Hi Nebu - Thanks a million!! In the variance file, the user will also use the month selection; start month and the end month. Only the selected months and the Total year figures should be displayed.Can you please help me on this as well Thanks Again Vishwas

Dear Forum Experts, I need your help on the below request. I have 3 work sheets 1. Actual [ will be updated every month] 2. Budget [ this data is already available] 3. Variance Actual data is as below Budget data has a similar format Variance Analysis is a result ( Actual -Budget) The...

Hello Can you please guide me on how to create a whale curve chart for customer profitability analysis? Thank you in advance

Hi Hui In the formula provided by you Output!C10: =INDEX(Sheet1!$C$6:$P$21,MATCH(Output!$B10,Sheet1!$B$6:$B$21,0),SUMPRODUCT((Sheet1!$C$4:$P$4=C$8)*(Sheet1!$C$5:$P$5=C_Contract)*(COLUMN(Sheet1!$C$1:$P$1)-2))) Can you please explain why "-2" is included in column function. Thanks

Hi Hui, Thanks a lot, it works exactly as I wanted. My intention was never to reject any help. All I was trying to do is to save time of other experts in the forum.Apologies for any inconvenience caused as a result of my post. Hope I will get help in the future. Thanks once again Regards

Hi SirJB7 Thanks I have taken note of your advice. However was wondering if I could get help from Hui as we were very near to get a solution to my problem. I could as well post it all over again explaining my request with an example Regards

Hi All , Need your help please Thank you

Hi Hui Thanks again. Though it solves majority of the problem, I still have errors in output sheet if B10 & B15 are interchanged. The output sheet elements in column B will change and it should always search for the exact match in column B of sheet1. In short all 3 conditions should match...

Hi All Excel Ninja's .. Can't crack the error on my formula .. I need to submit the report today and was wondering if I could get help. Thank you

Hi Hui.. is it possible to help me on this? thanks SirJB7 for your efforts Is there an alternate approach for my request? thanks