1. P

    Minimum If with dates

    Hi, I have a list of weekly dates in Column A and Costs in Column C. I am trying to find the lowest value of C if the date is before this week (as the values constantly go up, using min gives a misleading result as every week starts at £0. My formula (array) is as follows: <k11,c:c,""))[...
  2. H

    Code needed for Max & Min Values

    I have B2:B10 which are dynamic cells & keeps on UPDATING (based on time criteria) Corresponding MAXIMUM & MINIMUM values required in E2:E10 & F2:F10 Code required to accomplish. I am using Excel 2007. Thanks in adv. Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col...
  3. O

    Using MIN function in column with blanks

    I have a scoring sheet that lists scores in a column but never know how many names will be entered and want to find the minimum score in a column with several blanks above the formula
  4. H

    Randomly Distributing A Pre-Determined Sum Over 12 Non-Contiguous Cells

    Good Afternoon, Does anyone know of a way to distribute a certain number (say 25,000,000) over a group of non-contiguous cells, while adhering to a floor, or minimum number, for each respective cell? Also, formulas in the past have been "biased" toward the upper-most positioned cells (so that...
  5. F

    Minimum range of variable

    Hello, I have a "variable" (I think its called), called LastRow. And LastRow will find the latest row with data in special column. But if LastRow is empty. It will cause problems and delete information. Can I in some way set a minimum LastRow range? All help would be awesome! LastRow =...
  6. B

    Miltiple if and roundup question

    Hi All, I have formula with calculating order and after round in up to nearest 100. I have issue with one additional argument - if result is bigger then 0 but smaller then 500 round up to 500. As my minimum order is 500 after this its just 500+100 ect... any suggestions ? :confused...
  7. H

    If statement until..

    Hello, I'm wanting help with an IF statement. I am wanting to say If value in column G is equals or greater than the minimum (column C ) then 2750 until the value in column G is less than or equal to Max (column D) then 4000 =IF(ISBLANK(G3),"",IF(G3>=C3,2750,IF(G3<=D3,4000))) This is...
  8. D

    Subtotal minimum number that isn't zero

    Trying to get the following, but cannot figure the formula to get my desired output described. Subtotal(5,H4:H15) - the minimum number in a filtered list that isn't zero. Likewise, Subtotal(4,H4:H15) - the max number in a filtered list that is below 400 (or whatever I decide) Any thoughts...
  9. E

    Return A Cell With Multiple Criterias

    Need all your help. Thank you in advance. <colgroup><col><col><col><col><col><col><col><col><col span="9"></colgroup><tbody> Cells A1: Total B1: 16000 C1: Total D1: 17000 E1: Total F1: 16500 G1: Total H1: 17250 Row 2 K2: NO M2: NO O2: NO Q2: YES These cells can either be...
  10. E

    Double axis bar chart with different minimum values

    Hi All, I'm try to do what's set out in this post, EXCEPT I want to set a different minimum value for the two datasets I'm graphing...when I set minimum axis value to 0 on the left axis and to 1,000 on...
  11. B

    Minimum Value of 1.00 in Cell

    I have a cell that does not have a formula, but i need it to have a minimum value of 1.00 in it. it can have larger number in it, but no lower than 1.00, it must always have a value in it. Thanks for the help Chad
  12. B

    minimum maximum value formulating

    I am trying to put a corresponding value in a certain cell from a value in another cell. It will require me to do a "if this number is between two numbers in two columns" then it states the value to be inserted in a certain cell. I am having a problem figuring out what kind of formula to use...
  13. G

    Certain Cap

    How do I Cap if i want lets say -50% the minimum and +50% the max?.
  14. U

    Get Minimum Time Where Criteria May Be In Two Different Columns

    Hi, Using Office 365. I am trying to determine the minimum time an event occurred in the Work Breakdown Structure (WBS) The problem seem to be that the the event may exist in either Col V or Col W as the event updates from Old to New Value, some events may repeat. Any other thoughts how I can...
  15. R

    Min of 5 cells before different from 0

    Hello everyone, thanks for your time in advance. My first column are numbers, for example: A1: Column 1 A2: 10 A3: 2 A4: 10 A5: 10 A6: 5 A7: 0 A8: 0 A9: 0 A10: 5 A11: 5 A12: 5 ... Then in my second column calculates the minimum of 5 cells before that are different from 0. For example the cell...
  16. R

    I am trying to add exceptions to a formula

    Dear Sir or Madam: My name is Robert, and I have just one more Excel formula issue before I fall asleep. The following formula works perfectly, but I want to add exceptions to it. I need Excel to find a cell that contains "minimum", "maximum", and range" with any other words except the...
  17. A

    Finding column header

    Hello, I have data in 5 columns having header. Now in 6th column I have value which in minimum of that particular row. Based on this minimum value I need to get corresponding column header in 7th column respective to each row. Similar to table shown below: <tbody> A B C D E Minimum Header...
  18. Y

    finding minimum between 2 maximum number in an array

    hi, i have an array of random numbers and i need to find the minimum number between the first highest number and the new highest number that will come later on. for example 1,2,10,7,5,3,9,2,11 - 10 is the highest, than 11 is the new max so i need to find the min between - 2. that calculation...
  19. D

    Minimum and Maximum formula

    I have a work/marksheet where column BJ is the possible mark and Column BK is the actual mark. Column BL is the the percentage with column BM has a code for example C1. I have 7 sections in total. I have done the formula to pick out the Maximum and minimum percentage marks. I wan to output the...
  20. C

    IF condition

    I need help with what should be easy formula but I can't get it right. I have the following figures: <tbody> 2 2 0 0 10 0 0 </tbody> The average is 2, but I have a separate Formula which is a minimum of 2.5. How do I replace the zero values with whichever is higher of the average or the...

Some videos you may like

This Week's Hot Topics