formulas functions

  1. I

    Sorting a table the correct way

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

    In need of a formula wizard for calculations.....

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


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

    Averageif with Date range help

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

    Sum of a product with a date range

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

    How to keep total row in table current

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

    Is this possible without super advanced skills?

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

    Creating multi condition array formula? Lets try this again

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

    reverse vlookup

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

    editing formula

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

    Formulas start to calculate before cells are filled

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

    count duplicate entries

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

    Is it possible to have this automation

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

    IF problem...I think

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

    Help with formula please or code.

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

    Holiday Entitlement Excel Doc

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

    Extract words from the middle of a description?

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

    Help on creating a search function or search engine?

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

    Looking for help on creating a search...

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

    Conditional Formatting Using AND(OR) Formulas

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back