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:
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.
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col...
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...
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!
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...
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
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.
Subtotal(4,H4:H15) - the max number in a filtered list that is below 400 (or whatever I decide)
Need all your help. Thank you in advance.
These cells can either be...
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...
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
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...
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...
Hello everyone, thanks for your time in advance.
My first column are numbers, for example:
A1: Column 1
Then in my second column calculates the minimum of 5 cells before that are different from 0.
For example the cell...
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...
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:
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.
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...
I need help with what should be easy formula but I can't get it right. I have the following figures:
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...