goal

to try to keep it simple this is the equation I am working with (A+B)/(A+B+C+D+E)=% I am working this toward a goal % as the answer EX (A+B)(A+B+C+D+E)=15% Goal is 10% How many more "E" will I need to get to Goal any help would be greatly appreciated

I'm still new to this but can someone help me how to set goal seek "set cell" must be in ascending For example cell B83 "set cell" is the sum of B71:B82 (must be ascending) and cell B85 is the "to value" and cell b70 is "by changing cell" also, cell b71 is a hard code cell cell b72...

I have three columns in my pivot table. Status, Goal, and Forecast. My rows are Outlook Status (Booked, To Go, At Risk, etc). I want to calculate per status, the % of grand total goal based on forcasted revenue. Say I have 5 orders Goal Forecast Order 1 $5 $10...

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

I'm attempting to create a command button that will send the current sheet to someone as an email, but when I click the button nothing happens. Here is the code, and I'm not sure if I assigned it properly. Excel 2010. Thanks for the help. Sub Send_Range()...

Hi all, I'm after a formula to search for a string of text in range which is in the same row, and return the value of the cell to the left of where that value has been found. So for example cell A contain Names, then row B is where I'd like my "goal" to be, then columns C to G is the range of...

Took a VBA course a couple of years ago but man that knowledge went in and out :) I have x number of rows of data. I would like to run a macro that goal seeks by setting each cell in column R to 0 (zero) by changing the cells in the corresponding row in column Q, until there is no more rows...

Hi all, I’ve made up a spread sheet in which I change a variable (depth in my case) and then use goal seek to obtain a value for theta for that corresponding depth then manually record the value obtained. Is there a way to record the value obtained for that variable then change the variable and...

Morning Everyone I am hoping to get a little help. I'm stuck on my formula. Using standard Net Promoter Score surveys I am looking to calculate how many promoters are needed to attain goal. the formula we use is the following P=Promoter N=Neutral D=Detractor (P-D)/(P+N+D) What I have so far is...

combinations of numbers that sum to a given total excel I've got a column of numbers, and I'd like to find the best combination of three of these numbers. In our case, the best combination is a sum that is as close as possible to our goal number For example, we have a goal of 100 and this column...

Hi! I work in the food service industry as a store manager, and I'm trying to find a formula in Excel that will allow me to determine our new daily sales goals as we input previous day's sales to hit our target goal. My management team is not trained in Excel so I'm trying to make it as easy as...

Hello, I am need to create about 60 graphs for some data I have in a workbook. As I said in the title, my data is standardized. The thing is, I simple have no idea how to approach this since I have never dealt with something like this. My data, normal range, goes like this: <tbody> KPI...

Hello all, I'm trying to get a record stored for later use from a givenreport for the month of February, 2018. Because the report is Excel based Iwould like to store the data in such a way that Pivot table can be used for anyfuture requirements. Currently the report looks like this...

Hi, I have a target goal of getting a 20% XIRR return on 3/31/2018. As you can see. My current IRR is -97%. What formula would tell me that I need X amount for 3/31/2018 to reach my goal of getting a exact 20% XIRR? <colgroup><col span="11"><col><col span="4"><col><col...

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, Im trying to calculate a way for me and my colleagues to know how many remaining 5s we need to reach our target %. Since the target is 88% the only input that brings it up is the input 5 since input 4 is valued at "75%". Ive tried solving this for a few hours but i just cant wrap my...

What I want to do is make a chart like this: That shows score and when they happen. So a team score a goal at the 3 minute mark, their margin goes up 6 points, then a point at the 5 minute mark, they go up to 7 points, then at the 14 minute mark the other team scores a goal and it goes back to...

Hello, I need a macro to remove duplicates by row and also remove the blanks. Its a huge data by rows and columns below example - duplicates "Rob & "goal" to be removed, but should retain unique and remove the blanks <tbody> gulf Rob stat Rob aim hero fun goal view review page goal...

Hi all, I have a sheet where i need to split messy data in a single cell ending up with two clean cells. Here's an example: <tbody> A V AUTO SALES is in cell A2The end goal is: AV Auto in cell B2 Sales in B3 Here's another: <tbody> R & D MOTORS goal is: R&D Motors </tbody> </tbody>...

im trying to get yes or no if a certain cell contains the words own goal ? heres my prob in E608 ih have the words Own Goal James Russell this is what is use to use =IF(E608="Own goal","Yes","No") this would return yes if only it contained Own goal but now that ive added the own goal scorer...