I cannot manually do every single row (this excel is gigantic). Isn’t there some excel formula to do this for me automatically?
I tried: =MAX(B1:B18) – MIN(B1:B18). Here I get the biggest gap between B1 (47.32) and B13 (200), but this gap is bigger then 1 month = 9 rows, which it is not allowed to exceed.
I was able to calculate the gap by taking the difference between the MAX(B1:B9) and MIN(B1:B9) and then repeating this one row down at a time ( e.g. B2-B10, B3-B11, B4-B12, etc)
This of course takes up a lot of space but does the job. If a shorter way is possible then please let me know. If not then I only need one thing: I need the chosen rows with the largest gap between its max and min to be automatically highlighted.
I have a work document with multiple rows of information. In each row I need to locate the maximum and minimum values. (The rows aren't long - there are about 10 values in each). I then would like to turn the font of the lowest value in each row red - and the font of the highest value in each row blue. I would also like to be able to skip blank or unimportant rows.
I want to identify the column heading for the first, second and third most popular courses. ie for School1 the most popular course is Maths, second most popular is English and so on.
I have tried using the OFFSET function, which worked if I provided the cell location of the required value. I then looked at the ADDRESS function to provide the cell location: eg For School2 find the 2nd most popular course:
I have 3 columns. The first has names of students, the second names of their schools, and the third the student's scores. I need to add together the top 4 scores from each school and return them in a table. I have tried combining LARGE and SUMIF but to no avail. Also tried a Pivot table but I cannot get just the top four scores to add.
I'm working with box quantities and would like to get a formula that would take the box quantity and return the largest value based on some parameters. Here are my parameters:
Obviously options 2 and 4 are no good as I can only work with even break downs. This leaves me with either 3 or 4 and because I want the largest, I would choose number 3. What I need is help on a formula that will take the value of the box quantity and return the largest whole number. I think for the time being I would like to leave the break down between 2 and 5 as well.
If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned. But this is not correct as the value I am seeking falls with a range of Min/Max Values therefore the return should be the Next Largest Value
I have values I would like to lookup against a table Min Max values Col A Min Value 700,000 Col B Max Value 799,999.99
The value being sought is 745,000
I would like the return to be 799,999.99 But currently returning 700,000
Current formula is =VLOOKUP(G2,tblMaxValues,2,TRUE) Where G2 is 745,000 tblMaxValues is a list of values for comparison ,2, is the column to be returned
I have a row with 30 cells and each cell has a different value. i want to count the highest 15 cells of those 30, so the sum of the total only counts the largest 15 digits.
I'm using this formula to look up a certain value in "overview" sheet, is there a way to not show the result in this cell but show as result the cell in the same column in row 3?
I am trying to write a macro in order to find the largest value in a column in one worksheet, and copy and paste that value into a different workbook. I have found a code similar to what I am looking for and tweaked it, but it needs a few more adjustments. The code below opens the file I want it to, and pastes data into the correct workbook and worksheet, but I would like it to be able to paste in the next empty cell in Row 3, instead of just in the cell "C3". Also i would like for the program to find the largest numeric value in column C, instead of using an if last row statement, as this current program does not always give me the output I am looking for.
VB:
Dim wsMaster As Worksheet, wbDATA As Workbook Dim NextRow As Long, LastRow As Long
writing a formula to sum the six largest numbers from a row of numbers. I have used the array formula "=SUM(LARGE(E2:M2,{1,2,3,4,5,6}))" and it works for rows that have six or more numbers; however, not all of my rows always have six or more numbers. Rows that have less than six result in "#NUM!".
I am using excel 2007 and I need help with the following if anyone would be kind enough. I have a dynamic array that consists of stream of 1's and 0's. I want to be able to find the largest sequence of 1's and the smallest sequence of 1's. So at a point in time the array mite be 111110001101111000 and I want to be able to dertermine the longest contiguous sequence of 1's. But as I say the array is dynamic and so I need to do that after each input.
I have my data arranged in 4 columns as shown below (sample data). I need the Excel to find the largest value for each date and write them somewhere along with those dates. For example, the Excel should write in the 5th column (E) below two dates and values based on the sample data I listed below -
4/1/2007 - 0.044 4/2/2007 - 0.055
I have about 17-18 values for each date between 4/1/2007 and 10/31/2007.
Sample Data ======================================== A B C D --------- ---------- ---- ----- Date SITE POCConcentration 4/1/2007 11001002510.039 4/1/2007 11001004110.042 4/1/2007 11001004310.039 4/1/2007 24009001110.042 4/1/2007 24017001010.044 4/2/2007 11001002510.051 4/2/2007 11001004110.048 4/2/2007 11001004310.052 4/2/2007 24009001110.053 4/2/2007 24017001010.055 4/2/2007 24021003710.055
I have two sets of numbers..... In column B I have measured values. In column A I have the times for which these valus occur. I need to determine whether the measured values in B exceeded the max limit for more then a given time (ie do not exceed a value of five for more then 15mins)
with this Excel problem? I have a set of data of 300 some odd rows of numbers. I need to find 24 CONSECUTIVE values that add up to the HIGHEST sum? For instance,
write a udf function to deal with the above ?I know large(a1:e1,1) for picking up the largest one in the row,but no idea to find the largest one when these five numbers are combined to build a 5-digit number.
[ want to find largest 5-digit (also 4 ,3 digit ) numbers combined by thess five numbers]
