actual

<tbody> Goal 07/02/18 07/03/18 07/04/18 07/05/18 50 20 56 65 130 50 22 25 35 85 106 130 120 85 99 120 115 160 55 96 150 16 175 199 12 </tbody> Hi - I need a macro which needs to fill the colorindex=22 whenever the ACTUAL is lesser than the GOAL. For...

Hi, I apologise if this has come up before. I have tried solutions in other threads but they have not worked for me. I need to fill in the 1st table below with data from the 2nd table. I have tried to use a formula to pick up all MP/Compact or Compact sales for the month in that column but it...

Hello Forum, I have a total of 1400 columns which I will like to move into one single column. See example below. A B C D E F G Actual 1 rrrr uyuk strr sgrs ljho...

Hi there Not sure how to approach this, but the problem is as the title describes. I have columns that correspond to incremental weeks. On each row is a person's name. I want to calculate the sum of the actual number of hours worked by a person, depending on the week. The week is stipulated...

Hi everyone <o:p></o:p> <o:p></o:p> I would like to sum values which are in two columns – but only take values from column B if column C is empty. <o:p></o:p> <o:p></o:p> To provide some context, Column C is actual spend and Column B is forecast spend. When comparing against budget I want to SUM...

Hi All, As the most excel-proficient person at my workplace, I've somehow been tasked with creating an accounting and labor-hours reporting dashboard, even though I'm neither an accountant nor project manager (I'm IT). Ideally, my boss wants to track actual labor hours expended in the field vs...

Hi I am working on an excel file were i need to formulaize some of the rows for values and for some rows i have actual values. i need to determine every row for value formulaized as "forecasted value" and actual value as "actual". is ther any formula or way for that. thanks Mukesh

Hi, I have the planned numbers in cell A1 to B4. A1 - Planned Amount B1 - Planned Rate A2 - 200 A3 - 1770 A4 - 280 B2 - 92.1175 B3 - 91.9803 B4 - 92.07 Actuals are now from A6 - Actual Amount and B7 - Wtd Rates (These are headers) in A7 - 1820 (actual total amount) In B7 I need the weighted...

Hello, I am trying to sum values from the sheet which it's name is J1 to the actual sheet. Here is what I did: The Sum : =SUM('J1:Here I have to put the actual sheet'!O1187) Find the actual sheet: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) How can I combine both in...

Hi all If i would like to get the status column automated - i.e. to check the actual time in against the shift time to determine if employee is on time (early), on wrong assigned shift (check) and late, is there a way to do it? I tried =if(or( etc and didnt work... <tbody> Shift Time Actual...

I have a table that looks something like <tbody> Person Month Target Actual Variance % A Jan 1075 1500 28% B Jan 4109 4950 17% A Feb 1084 4000 73% B Feb 1000 2250 56% </tbody> The pivot table has a slicer that filters by person which works great when only looking at one at a time...

Hi all. I have the following formula: =IF(F10=“YES”,SUM(E10-D10-25,IF(F10=“NO”,SUM(E10-D10),IF(F10=“”,””))) What I am wanting to do is somehow in the first part as below, if the answer is a negative number then the answer will convert to 0 instead of the actual negative value...

Let's say that in sheet1 cell A5 I have the text version of a web address. What I'd like to do is use VBA to place that information into sheet2 cell B7 and turn it into a clickable hyperlink. It would also be nice if the cell just displayed "Link" and the actual address was not visible. I'm...

I'm trying to learn about basic array formulas. Following is my example: Booked Actual 33 32 9 16 8 6 21 30 27 25 16 16 13 43 19 49 Formula: {=sum(c4.c11>=b4.b11)} - entered without the brackets, using...

Hi,I am new to this forum (and new to VBA!) Here is my issue (which I'm sure will be simple on here!) I have a table with both period nos (ie 1-13) and weeks nos (1-52) across the top. I have a formula that copies data from from one file to another into each cell of a column of 20 items for...

New to the forum (Hello!), please forgive me if I am posting my question(s) incorrectly. I have been working on this all day and have hit a wall. The table that I am building is below: <tbody> A B C D E F G H I J K L M N O P Q R 1 Property Target Price Actual...

Hi, I would appreciate assistance creating the correct formula to : SUM columns B, D and F ONLY if there are figures greater than zero in columns C, E and G (The result to find the YTD Budget in column H) I have tried numerous with not much luck! Thanks <tbody> A B C D E F G H Jan Budget...

I am attempting to get the value of a cell that is located on a different sheet/Tab. But, the actual Cell location is on a different tab.... Seems odd, but bear with me. I want the value from the Sheet Titled "Daily Report". The actual Cell I want on that sheet is located on the tab: "Set...

I require 24 hour time to be formatted in cell D11. What happens is the actual time may not get entered until later on Example: The current time is say 13:30 but i need to enter the actual time achieved which was 10:30 in D11 What is the easiest way to achieve as i want 24 hour displayed...

Hello, I have a pivot table that shows the usage of a material. It shows the target amount of boxes, the actual usage of boxes and the variance between the target and actual. The columns are in the values field. I can't seem to find a way to get excel to use the values field to create a...