Search results

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.

Hi, Is it possible to create the chart as per the attached file, displaying the average value for each category?

Hi , Grah, Sorry for the later response. The formula is working perfectly, is it possible to hyperlink the cell C18, once i click the cell it should go to particular sheet inwhich the formula is there for ex. If i click C18 it should goto sheet1 and C19 it should go to sheet2 accordingly.

Hi, I am consolidating the summary of 100-200 projects, in a file there will be 100-200 worksheets naming 1,2,3,4....upto 100 and it may increase also. I am preparing the summary sheet in that I want to the formula for copy and down instead of linking in each sheet. Find below the summary...

Thank you AliGW, formula working perfectly. Thank you very much for your time .

Aligw, I am preparing the performance review status. If the performance review is completed on the mentioned date B1 then in C1 will reflect Completed. Find attached the file hope it will give more clarity.

I want to update the status based on the formulas. In Column B I have dates and In Column C next to date will be blank or YES. In column "D" I want the output based on the following requirements. example : If C2 "YES" then output will be completed C2 is blank and assume today is 13/2/2018...

Rahul, Sorry for the late response. Thank you very much , it worked perfectly.

Hi, Rahul Thank you very much, its working perfectly. I need little more clarification I had copied and pasted the code in other file and its showing the error. I am sorry can you please explain it. where I am doing mistake.

Rahul, Thank you very much, it's working perfectly. Is it possible to insert the Refresh button in the sheet "Wksoutput", I want to hide the sheet "Wks data via power query" so that the team will update the 3table(Bangalore,Delhi, and Mumbai) only.

I need a code to copy data from sheets WksBangalore,WksDelhi,WksMumbai and paste in the sheet WksData. Find attached the excel file. I wanted output as shown in the WksData sheet. At present I copy and pasted in the WksData sheet.