formulas functions

Hi In the example below on columns N to P I am trying to get a sorted array (smaller to larger) with the following Automatic entry times if they exist (no limit of entries) And after that the Minimum entry times follow (limit of entries is specified in P4). I have sort of done it (tables...

I really need some help with a formula for a cell to calculate a figure based on another cell. Below is an illustration of the formulas that are needed. I am trying to take a backdoor approach the cell formula due to I am unable to use the indirect process like with multiple sheets in excel on...

i just took a class on excel, we learned a bit of formulas so now a day later i am fooling around and trying the new things i learned, however i am getting different results. i made up a quick fake spread sheet, consist of amount of money a individual makes each quarter, i was trying to get the...

Hey guys, got a tough one that I need help with: <tbody> <tbody> Date Devices Installed Lead Time on Site (Hours) Non Lead Time on Site(Hours) 3/11/2016 2 2.00 3.00 3/15/2016 5 4.00 6.00 3/17/2016 1 1.00 4/1/2016 2 1.25 0.75 </tbody>...

I am trying to get a sum of something (devices installed) that is in a specific date range. <tbody> Date Devices Installed 3/1/2016 2 3/12/2016 1 3/15/2016 2 3/17/2016 1 4/3/2016 1 </tbody> <tbody> </tbody> Basically I want a sum of all devices that were installed based off of...

I'm in the process of making a register book on excel with a total to keep up on the changes so it can stay current on a different sheet what type of function do I need to use with this

Hey there, I am trying to understand how to create a formula that would pull what I currently have in the Input Cells automatically when I update the other spreadsheets. The cells will change as I update, but I still want it to give me the sum for what I am asking for. For instance, on the...

For those of you that looked at my old post, I am sorry. I tried to post with a screen shot and it didn't work. I tried to modify and delete without success. Here is my question. Hello, I posted a tread a while back and received great feedback. I'm working to automate the following...

i am trying to make vlookup reverse so it will take the number from a cell for example # 3 , scroll down the chart looking for a certain name then move 3 cells sidways and place # 3 there Thanks

I need to edit this formula but I am unable to get the equation to work after editing the values within the equation. See formula: {=AVERAGE(LARGE(SUBSET(9,OFFSET(O2:O271,LARGE(IF(O2:O271<>0,ROW(O2:O271)-MIN(ROW(O2:O271))),ROW(INDIRECT("1:10"))),0,1)),{1,2,3,4,5}))} I am trying to change O271...

Excel 2013 I created a Physical Fitness Test workbook that scores participants on four events. Scores are based on the person's age and counts on the exercise. For example, a 22 year old has to do 55 pushups while a 42 year old only has to do 44 to get 100%. I created four tables with a two...

I have a column of job numbers (A) and associated info in other columns related to the job number identifier. Sometimes a job will have a number of tasks so the job number will appear multiple times. I'm looking for a formula that will count the number of duplicate job numbers when they occur...

I have a list of Countrys and the related Country Codes within a worksheet. I need a formula or Macro that will allow the Country to be entered and then the Country Code that related to that country to automatically replace the Country. I am using excel 2010. An example is that in H1 the user...

What I am trying to do is make excel populate information automatically from one sheet to another. I'd like to say, "IF the value in ANY of the cells in a selected column are greater than 1, then populate the information in the ROW cells from which the column cell is located." I.e. if my...

Hello I have a very difficult task of putting averaging daily returns into months. The problem is that I have to look through 2430 * 10 rows month by month and put in average (H1:H30) is there a way so that it would automatically calculate average from 02/11/2005 to 30/11/2005 - the point is...

HI, Am trying to make a holiday entitlement document for my business and need some help on the formulas as am rubbish on excel. I have found a excel doc on this site but cant get it to work. Start Date 25/03/2010 Staff Name Hol Year Start Hol Year End Accrual Start Date...

ARLINGTON AWR.24"X30" Double Door Wall Cabinet (KITCHEN) OAK I want to extract the "Double door" from J3's description and fill into a new cell like jj3. I tried =mid(formula) as it states in the help. But it didn't work. Help....

<table border="0" cellpadding="0" cellspacing="0" height="765" width="3141"><col style="mso-width-source:userset;mso-width-alt:5302;width:109pt" width="145"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col...

<table border="0" cellpadding="0" cellspacing="0" height="695" width="2947"><colgroup><col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col...

I can't find this answer anywhere on the internet, so maybe I need to do it a different way. I want to compare current month cell to prior month cell as a percentage (AC5) AND greater than an ABS dollar amount (AB5). I have the formula below which I created in excel 2003, but I can't get it...