actual

Hello, I'm trying to match on 3 criteria to return a result, but no matter what I have tried it hasn't worked. In the example attached I am trying to match "Rms Cable Television", "Jan-18", and "ACTUAL" (all in bold below), to return a value. The formula I am attempting to use is...

I realize the title of the post is not congruent with what I suppose about data modelling... However, I am trying to capture a measure in a column rather than calculate 15 different measures just so my chart looks like it needs to. First, I am using excel 2016, and not PowerBI I have a...

Hello Everyone, I'm afraid i am not able to put the picture of the file for better understanding. Though, i tried and failed. I will try my best to explain. In the below grid-1, in front of the date (1-Feb), i want to insert a formula that uses the grid2 (mentioned even below). The formula...

Hello, I am hoping to get help with a formula that will sum a set of cells, unless there is a value present in the cell to the right. More specifically, I have a spreadsheet that lists an "estimated" number for the month followed by the "actual" number for the same month. I would like to...

Am not good at macros and need experts here to help me. Find below the sample data in sheet named "" <tbody> Name training 1 training 2 training 3 goal actual goal actual goal actual res-1 8 5 8 6 N/A N/A res-2 9 8 8 7 9 4 res-3 6 5 8 3 N/A N/A </tbody> Data to be populated in...

Hello, I hope y'all doing well. I am having a hard time trying to get a pivot graph showing a Plan vs Actual based on counts of ID's and dates. <tbody> ID ID_Name Status Plan Date Actual Date 1 UAT Pass 1/28/2018 1/30/2018 2 SmokeTest Fail 1/31/2018 1/30/2018 3 YourCodeIsBadTest Fail...

<tbody> 0 10 20 30 40 50 60 70 80 90 100 121.8 124.5 127.2 129.9 132.6 135.3 138 140.7 143.4 146.10 148.8 </tbody> Given the table above where in the first row is Weighted while the 2nd row is a target value. If i have an actual value of 132.6 the result (as per the first row is 40), My...

Hi I am using Excel 2013 and looking at setting up a pivot table and chart to show: Freight Cost Freight Budget Variance % I can't seem to get the variance column to show the percentage change between actual and budget correctly Can anyone help me with a formula? Thanks

Hello All, Need some help please - I have a vast amount of numbers in a column which have been converted into a scientific notation i.e. 1.23E+10. The problem is that the notations are in text format, I need to convert them into the actual number i.e. without the 1.23E+10 and into the actual...

I actually don't know how to word this topic, but I have a set of data, and I'm trying to create a bar chart so that it has actual vs plan numbers. My data is structured in such a way that I have a "Year" column, a "value" column, and a "type" column. The type column has 2 values: "Actual"...

Hello All, I am trying to figure out a formula for the following: I have three tabs in an excel workbook for an accounting project: "Variance," "Actual", and "budget." Each tab has a unique GL# in column A followed by dollar amounts in the next columns representing the month. All the tabs...

In theory I love Power Query. I've run training etc with examples of ugly data that's a few hundred rows and it all works like dream. In the real world, when I have an excel with 500k rows, using it is agony. I have no problem with lengthy processing time, I can run that over lunch or...

Hello Everyone, Can anybody please help in the attached image below: I want to get the actual result in Column H when adding the Column I. Many thanks

I had some great help last week relating to this post; Index, Match,or List?? For the most part everything is working except that the formula I am trying to use to pull out the actual distances in the cell is not working? The spreadsheet is huge bu I can show you the formulas that are working...

All, I was typing away in a cell on excel when suddenly, I noticed all my columns expanded in width. When I look at the actual column size number, they didn't change. How do i get this spreadsheet to go back to normal? Thanks, Dan

I have a below data <tbody> Month 1,056,244.83 Actual Rate Completed Tenor Rate Actual Rate Profit Completed Tenor Profit Rate Differential Differential Rate New Profit May-2017 13 5.40% 4.29% 2,031.46 1,613.88 1.08502410% 4.31% 1,623.28...

Hi, Writing after so long, I have a problem with Pivot table calculated field. let me explain. I have Data which gives me Budget and Actual. The column which distinguish Actual and Budget is names "Type" I have a pivot table which gives me location wise bifurcation of Budget Vs Actuals. Now I...

Hi, I'm making a financial scorecard in excel and are making a sheet called database to get the data from different sources. I'm getting cost data (actual and budgeted) from a Pivot table in a different workbook. I've used VLOOKUP to find all the values for actual, but the problem is that to get...

Hi All.. When I use = TODAY or = NOW, excel shows the date based on the computer system. And as we know that function (Today and Now), will change and produce value according to the date on the computer I was wondering, is there a way to store actual date data even though the computer's date...

Hello, I have project Im working on, and currently the thing I am doing is searching each cell, from one sheet(Datasheet-C), as each row is copied, to another sheet(Accredited), in a loop, for values or text. That part is working. But I have several cells that contain the Plus/Minus symbol...