Search results

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

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

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

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

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

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

All, I have the following 5 sheets in a file WksOutput,WksData,WksBangalore,WksDelhi,WksMumbai. I want to copy data from WksBangalore,WksDelhi,WksMumbai to WksData sheet continuously. I am using the following data Sub Combine() Dim J As Integer On Error Resume Next Sheets(3).Activate...

All, I have a data on one sheet and required to copy the data in the desired format in another sheet. I wrote the code for date and rate to copy but it's not working properly. Please do the needful. I am learning VBA from 2 months.

Hi, In the attached file , the formula in cell "EY22" is not working properly . It's taking the value of particular column only . Also, help me with formula with minimum quantity( >0) and respective vendor name.

I have text in merged cell a2:a4 ( Details of payment,q4 order summary report-completed wt & dimension CA14-3345 - Completed engraving : Acme - Progress Tenon scienc & technologies - Completed SBC @ 0.5% pay tax - Pending Service tax 12.36% to 14% - Progress ) I required formula to count...

all, I am using the formula IF(C33>B33,$H$32,$G$32)&TEXT(((B33-C33)/B33),"#%"), but i am getting the result as ▲51% .... but i need in 2 decimal places...like 51.38% G32 ▲ H32 ▼ B(33) C (33) 8368219.99 12668219.99

All , I am having 1000 + rows like below mentioned here , I want the difference mat In Column A there are 3 numbers separated by forward slash The first number is beam number the second number is node number The third number is load case number I required difference of Fx matching the node...

Hi , I required help in creating Slicer as per the attached file. I Had done one slicer of Project Type and i required another slicer as Package and chart updating it.

Dear All, I want to format the -ve number like -1,557,896 to (INR 15.57M) Please do the needful

Dear All, I am looking for a lookup and match formula, In sheet 1, I want a formula for invoiced amount and payment received month wise , where the data is in sheet 2 as per the attachment . Not getting how to proceed with the formula , tried Vlook didn't succeed.

In a sheet range a1:x25 , i have a set of 30nos staggered in the range and some of the cells are empty. The result i want from A30 in column wise all the numbers in a range.

Dear all, In sheet1, I have 2 columns date and currency ( USD, EUR, GBP , YEN) , in Sheet 2 I have 5 columns ( Date , USD, EUR, GGBP,YEN ) as mentioned Below I need formula in Sheet 1 that matches date and currency wrt to sheet 2 , I am using formula...

Dear All , Find below the Link i require formula to complete the project on following 2 options. i) Nos of month required based on current progress ii) If the project has to complete within Aug-13 what should be the productivity every month. Please find below the link for the file ...

When i copy the dates from one file to another the year changes , even i f copy and paste special also the it changes. Any particlar reason?

Dear All, I am not getting proper answer , what i required please do the needful A B C D E F G H sL qty rate min max rate-a 2 500 57.5 57 58 57.5 3 1256 46.02 45 46.5 46.02 4 452 44.44 45...

Dear All, I have 2 Sheets where in sheet-2 my co-efficient are calculated , i need a formula in Sheet -1 with respect to the Nos For Example in C2 if i mention 2 then corresponding to sheet 2 wrt 2 i need 0.541 and 0.459 in "D" and "E" column same way if i mention 4 i should get values in...