Recent content by vishwas

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