Ciugk

Clash Royale CLAN TAG #URR8PPP Linear aproximation in excel between ages so I have a problem with linear aproximation in excel, see the data below... Age X1 Population 20-24 11 1243 25-29 13 3411 30-34 15 3973 What I need to do is that I have data like these and I want to calculate X1 not for "Age" between ages as you can see but to calculate it for every single age, so not 20-24 but 20,21,22,23,24...For that I have population info, so I know that for 20 there is 200 population, 21 231 population and so no... Really apreaciate your help! How are you doing this now, without excel? – Ron Rosenfeld Jun 28 at 19:04 I may be stupid but how do we know that 20 = 200, 21 = 231, etc? – Scott Craner Jun 28 at 19:12 ...

Clash Royale CLAN TAG #URR8PPP Excel: Check to see if Two Values are Between Two Other Values I am having a nightmare of a time trying to find a solution to this problem, and am hoping you wizards can help. In the example below, I have a dataset (columns A through C), and reference columns (F to H). Column D is the desired output for the formula. This column has been populated with an example of the output I want. Table 1. Table 1 shows my dataset. My goal is to generate (using a formula) an output in column D that classifies whether data in rows 2-14 in columns B & C fall within the start and end parameters of my reference dataset in columns G & H . If true, the formula should return the line number as shown in column F where the match exists in column D . column D rows 2-14 columns B & C columns G & H column F column D Using IF(AND( formulas, I was able to figure out how to do this so long as the start and end of B & C were >= to G , and <= to H . Examp...

Clash Royale CLAN TAG #URR8PPP Finding a cell in row, then using that cell reference to find vertical cell within range of cell reference Sort of new to Excel, so not sure if this is possible. In Sheet 1 I have the fixtures of teams playing in matchday 1; A B C D E ---------------------------- Matchday 1 Team 1 - Team 4 Team 2 - Team 5 Team 3 - Team 6 In Sheet 2 I have the previous years fixtures A B C D E F ---------------------------------------------------------- Team 1 Team 2 Home Team Result Away Team Home Team Result Away Team Team 1 1-0 Team 2 Team 2 0-1 Team 1 Team 1 1-1 Team 3 Team 2 2-1 Team 3 Team 1 1-2 Team 4 Team 2 0-1 Team 4 Team 1 2-2 Team 5 Team 2 1-1 Team 5 Team 1 1-0 Team 6 Team 2 3-1 Team 6 I want to be able to get the home teams name in Sheet 1, fin...

Clash Royale CLAN TAG #URR8PPP Weekday and Workday Formula gives Value Error in terms of calculating actual due dates I'm working on calculating our work completion dates, and I want to think I have a pretty good understanding of IF statements, but I can't seem to figure this one out at all. So we have three products: policy, quotes and rating, and they each have their own service times/dates process. - If a policy is requested before 4 pm, then it has to be completed the same day, otherwise if it comes in after 4:00 pm, then you have till 11:59 the next day. - With quotes you have 48 hours to complete them, and with rating you have 7 days. I also have a lookup sheet which references company holidays, and I decided to use workday function because some services get in on Fridays, and we are only count weekdays when calculating our due dates. I have also attached my formula in text below, do you guys think that I'm messing up in terms of how I am using both (OR) and (AND) fun...

Clash Royale CLAN TAG #URR8PPP Excel Formula to compare columns and output a value? Based on fields containing the Release Name and Change Date, I need to determine in what stage of that release process, the change occurred. In the example below, the change occurred in the January Analysis stage. I need to do this a few hundred times, so I need a formula that will get me there. You are given a Month and Date. You will see the month, phase, and date range(Start & Calculation End). The month and date range are used to determine the phase. Therefore for January 10/10/17 falls between January 10/9/17 - 11/5/2017 which would put it in the Analysis phase. I hope this clarifies the issue. Below is a link to an image of how the Stage is determined and spreadsheet is setup. Phase Determination Release Date January 10/10/2017 Release Stage Start Calculation End January Form Release 8/14/2017 9/10/2017 January Requirements Review 9/11/2017 10/8/2017 January Analysis 10/9/2017...

Clash Royale CLAN TAG #URR8PPP Excel Formula Help (Subtract 1 from values in column until 0 then move on to next value) I am trying to figure out a problem in excel and I can't figure out how to use a formula to get the answer i want. I have a list of numbers in a column. Column A. Ex. 16,1,6,1. In another column B I would like it to subtract 1 from the first cell until 0 is reached and then move onto the next value and so on. So for example, column b would be 15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0,0,5,4,3,2,1,0,0. Any help would be so great. Thank you! I have tried using the max function but I don't quite understand it. 1 Answer 1 in the A1 cell have your value at 15. In B1 use the formula =A1-1 . Then drag that formula across all cells in that row and it will keep subtracting 1 from the cell value on its left. =A1-1 By clicking "Post Your Ans...

Clash Royale CLAN TAG #URR8PPP Pasting Values from Source Worksheet with Formulas I am new to VBA and was trying to develop a simple macro that would automatically pull certain data from defined worksheets and ranges (always the same columns, varying rows) out of many different workbooks stored in a single folder and consolidate them in one master sheet by pasting the info into predefined columns with all the rows under one another. Through the help of this site I was able to develop the below code, which does exactly what I need. However, I am running into issues as the source information has many formulas, which, when moved to the master workbook, return '00000000' instead of the correct value. I believe the problem is due to the fact that my macro is trying to copy and paste the underlying formulas (if I change the source info to values it works fine) instead of converting them to values before pasting. As such, what I think I need to do is modify my macro so that it onl...

How to compare numbers in two columns in a excel sheet I have two columns - Column A has 13 amounts in 13 cells. Column B has 5 amounts in 5 cells. The total of Column A and Column B is equal, however, the amount in one cell of Column B is equal to a sum of two or three or four cells (I am not sure - because that is what I have to find) in column A. I want to identify the number of cells in Column A whose total is equal to the amount in one cell of column B. In the below example: the amount in first cell of column B which is 22 is equal to a sum of first five cells in column A (2+3+5+4+8) and the second amount in Column B, which is 91 is equal to sum of seventh and eight cell (85+6). Excel Example Please help me how do I identify/highlight the cells in column A whose total is equal to one cell of column B. Regards 1 Answer 1 This will identify the cells, but does nothing to its formatting (no cell h...