Search results

Hi I'm trying to write up a formula to convert the minute into percentage of an hour (Eg 2.25 = (25/60)+2) I'm struggling to get the correct formula to work. Any kind of help would be appreciated. File is attached with the formula which requires modification. Thank you.

Hi I’m currently using a vlookup formula in my summary tab for each of my heading in Cell E1 to H1. For the vlookup to work I need to sort the data by type first. Is there a better formula to use without the need to sort the data by type. Any assistance will be greatly appreciated. Thank you.

Hi I'm wanting to know how show percentage as a value in a pivot table. I want to know how to remove calculation. I tried using the value field setting and choose no calculation but it's still showing the percentage as a calculation not value. Also in the subtotal column, i don't want to show...

Hi I would like to know if there is a formula i can use to give me a certain result Example : I want to select a destination state ( Column D) and then it will automatically give me the free time(colomn G) from the different shipping co (Database worksheet) At the moment I can only get the...

Hi I'm trying to put together a pivot table to show the values only but for some reason when I drag the range into the Value section and I click into the value field setting and choose show value as . It's gray out. I don't want to show the sum of the values just the value as it is. Please help...

Hi I've combined a sumifand indirect formula but its only adding figures in one column instead of two Can anyone correct my formula so that it adds two or more column . Below is my formula...

Hi I used a vlookup and match formula in my excel spreadsheet but for some reason it's not working properly. Can someone please check my formula and advise what is wrong. Please refer to my excel file. My formula is in the Rates column (AH4) It's not picking up the correct rate base on the...

Hi I would like to know what formula I can use to pick up the total WE hours. Please refer to attached spreadsheet Thanks

Hi I'm having problems with my formula's and hope someone can guide me. Formula 1: Please refer to attachment- Worksheet "Graph Data" - I've inserted a vlookup & match formula from range C2:CT29 but it's not picking up the values. don't know what I'm missing. Formula 2: Worksheet "Graph Data"...

Hi Does anyone know if there is a formula to pick up the amount and spread it base on the order date. Like the example below: Order Date Amount Jan14 Feb14 Mar14 Apr14 May14 Feb14 50,000 50,0000 May14 12,000...

Hi I'm trying to write a formula to calculate the no of weeks from a fix date. Eg. what is 52 weeks from 30/06/2014.

Hi I have a problem with excel vlookup, when I insert a vlookup formula in my spreadsheet in Cell B3:B7 It will just pick up first answer all the way through. When I double click each indivual cell the answer will change to the correct one. Please refer to below example: B4 should be 15...

Hi I would like to know if there is a formula that will give pick up the start and end date as per the below table. Thanks. Start End Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Feb-12 Apr-12 1 1 1 Jan-12 Jun-12 1 1 1 1 1 1 Mar-12 Apr-12 1 1