# goal

1. ### Calculation issues.

I am having a hell of an issue that i can not figure out. So I have 6 teams with three months of data I need to track. Each team has a goal they need to achieve each month based on how many people are on that team. This goal changes with the number of people on the team. This is at the bottom of...
2. ### Percentage of a percentage?

I better explain this right, i would like to present in a cascade chart the participation of a category in the percentage fraction out of goal. Any guide will be highly appreciated. From the table below in PowerBI I have the following: On Goal = 8/18 = 44% What i would like to present is the...
3. ### Change Events with multiple instances of Excel

I am using the multithread tool by Tomasz Kacprowicz at http://analystcave.com/excel-vba-multithreading-tool/ Usually this tool works great but is failing for a new model in which a Sheet_Change event is used to automate the goal seek function. When the model is run with only 1 instance of...
4. ### Goal Seek not working in my office 365

Hello Evryone I have a problem in my office 365, in using goal seek When I use it, it change the set value by the value i has entered without changing the cell that must be changed This is an exemple A1 = 1 / A2= 2/ A3= A1+A2=3 (My goal is to have 100 in cell A3 by changing A1=> The...
5. ### Goal Seek or similar to amend several cells rather than just one

Say there is a value in cell E1, which has been calculated from the contents of cells in column D. With Goal Seek one can alter the number at E1 by changing one of the cells in column D. Rather than altering a single cell in that column, should I need to more than one to obtain the required...
6. ### Goal Seek Analysis "If cells are less than 0, than 0" isn't working.

WhatIfAnalysis Macro ' ' Keyboard Shortcut: Ctrl+g ' Public Sub GoalSeeker() For i = 3 To 187 cells(i, "AG").GoalSeek Goal:=0.15, ChangingCell:=cells(i, "AF") cells(i, "AF") = WorksheetFunction.Round(cells(i, "AF"), 2) cells(i, "AF") < 0 = 0 Next i End Sub
7. ### Goal Seek shows correct answer but won't stop iterations

I am running goal seek on two different workbooks. WB1 has an interest rate that modifies the value of the other workbook via basic multiplication. I am goal seeking the sum of the products. When I step through the goal seek iterations, it lands precisely on the sum I want. But goal seek...
8. ### If, and, or

Scenario: I am trying to find the best way to search one row across ten non consecutive columns to see if criteria is met. This row is one of a thousand and the columns are ten of ninety-five. My goal is: If B3="V" AND AF3="B" AND Q3-AQ3 <=|2.25| OR AH3="B" AND Q3-AS3 <=|2.25| OR AJ3="B" AND...
9. ### Using an "indirect" formula without a cell reference

Hello, I'm not sure if something like this is possible, but if "Indirect" is possible, I'm sure there is a way to achieve my goal. Here is my dilemma. There is a formula I need to use: (formula 1) =T:T&" "&IF(AA:AA<16,1,IF(AND(AA:AA>15,AA:AA<31),2,3)) Example output would be: AM DIY 3.2OZ...
10. ### Is there a formula that adds, subtracts, multiplies, and or divides two digit numbers in a single cell?

Are there formulas that will add, subtract, multiply, and/or divide data from two-digit numbers in a single cell? I appreciate any help I can get. Thank you in advance.
11. ### How to handle percentage to goal with 0 and a negative number

Hello! In my day to day job, we have goals set (for each month) that can be either positive or negative "net adds", and I can reach negative or positive actual net adds by the end of the month. I am having issues getting excel to populate my percent to goal under the following parameters: My...
12. ### Matching and summing matches to distinct values for multiple rows over multiple columns with blanks

My data has multiple pairs of a "name column" and "hour column" that corresponds to third value in another "movie column." The names aren't always the same in each column and can sometimes be blank or repeat. I'm trying to match and sum across all of these columns. The end goal is to have a what...
13. ### Need 2 Formulas

I do a Financial Spreadsheet for my boss. Lets say A1 is our revenue. B1 is staff cost. C1 is a percentage of cost to revenue. D1 is the difference of C1 to our Goal of 22.5% Is there a way C1 can turn Red if the Percentage exceeds our Goal of 22.5? Is there a way D1 can be Red if the...
14. ### goal seek using vba ?

I have a macro that calculates a function. There re 3 inputs to the function Often I use the excel spreadsheet to do a goal seek to set the result of that faction by allowing one of the inputs to vary Is there a simple way to program this in vba or do I basically have to write a complete...
15. ### Target Calculation formula

Below is a sample table i'm working on. We have an opening number for each member in B and a target closing number in C. Column D is the actual closing number. e.g. Mem5 target is 17,000 and closing is 17,000, Column E should show 100%. Mem4 target is 18,400, but opening and closing are same at...
16. ### Formula Help| Finding Time depending on attempts

Hi Guys, I have a table like this: <colgroup><col><col><col><col><col></colgroup><tbody> Current Attempts Current Average Time Goal Remaining Attempts Time I need to get to goal 50 250.00 210.00 25.00 > help here < </tbody> I'm looking for a formula on how much time I need to get to my...
17. ### Goal seek

Hi guys, Im looking for a sub goalseek that involves a loop making U8:U207 = 0 by changing the values in b2:q12 thank you
18. ### Conditional Formatting & VLOOKUP

Hi, I can't seem to get this to work. Any assistance would be greatly appreciated. I am trying to use conditional formatting on sheet 1 to highlight green any sales months that the seller was over goal based on their goal data on sheet 2. Sheet two contains the seller's goal data. I need to...
19. ### Goal seek with Rand values

Hi Folks. I'm looking to randomize some of the inputs to a goal seek calculation that I can run multiple times for different random values. This creates the problem of goal seeking on continually generating random values which doesn't work. is there a way to freeze the random values functions...
20. ### VBA - Goal Seek where columns change each week

So I'm trying to create a quick and easy goal seek macro, but every week the columns will shift over 1, so setting a static cell won't work. Is there a way to offset the goal seek or have it find a certain value and use that column? This is what I have so far, but I can't seem to get further...

### This Week's Hot Topics

• VBA code giving errors and stopping Excel
Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
• Disable MsgBox message
Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
• Macro Recorder into VBA, Copy Paste Data Filled Cells
Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
• Number format changes while pasting into a cell
Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
• Collating data
Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
• Sum Multiple Columns Based on Multiple Criteria
I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...