Recent content by vmohan1978

Hi can you please let me know how you shown the details in column?

Hi I updated the result required in output by applying sum formula. I need it in dynamic way based on the selection of Month and selection of designation. Hope I explained the question correctly?.

I Used to Calculate month wise. but it was not Dynamic formula.

All, please help me with the formula in the output sheet tab.

I am preparing the 80:20 rule by knowing the top 10 items of vendor A corresponding how the other vendor quoted. Using the large function, I arrived the top 10 items of vendor- A in column C 32: to C41, based on the value in C I arrived the name in Column B32 to B41. ow B31 and B32 I am getting...

@Peter, I used named function to use as drop down in the sheet. Thank you for your help.:)

Thanks Peter and Pecoflyer for your time and support. @ Peter can we use country validation and City validation as drop down in the sheet "Sheet1"

All, I required help in data validation whether we can convert range to table so that it will update dynamically from the attached sheet. Region Asia Ocania Country India Drop down menu in D4 should reflect only countries related to Asia Ocania City Drop down menu in D5 should reflect...

Now i getting the error #N/A. I think you had applied the formula considering the exact match of value like(30,50,20) in the case of Conf. room if the value is other than 30,50,20. Suppose if the value is 22, I should get nearest to the given range is 20 then i should Team-Based Work / High...

Hi, Sorry for the late response. Formula working correctly if i want to match approximate value then how can i modify it.

All, I required a formula in the attached document from cell C9 to C14 based on the value B9 to b14 , The formula should pick up answer from range B1 to D1 depending upon the values from B2 to D7 based on the meeting space. Please find attached the file and do the needful. Regards, Mohan

All I require the formula based on the value in column "C" and "D" I want the value in column "F" Column C Column D Column F Smt Smt 1 Smt Sft 10.764 Sft Sft 1 Sft Smt 0.093 Rmt Rmt 1 Rmt Rft 3.28 Rft Rft 1 Rft Rmt 0.305 Cum Cum 1 Cum Cft 35.28 Cft Cft 1 Cft Cum...

All, I am preparing the Pareto Analysis and need to identify the highest 30-40 items in the attached file in the required format of Output. Please let me know is there any formula or advanced filter to be used. Regards, Mohan

All, I am having 2 sheets one is summary and another sheet is a payment made to vendors, in summary, I want the payment details as per the details mentioned I can do with the pivot table but I want to find out amount using formula. please do the needful

Hui, Yes, I was expecting the same I was scratching my head from last few days to prepare the chart like this, unfortunately, I was unsuccessful. Thank you very much for your support.