Cell Of Maximum Value In Another Column
Apr 26, 2007
I have a problem looking up the cell at which a maximum value in a curve is located. I have attached a workbook with an example of my problem (this is scaled down to limit the size of the attachment – my usual string of data is 5000 rows long). Column A is the time and all subsequent columns will contain force values (as shown in columns A and B) which create a similar sharp curve.
Ideally I need to be able to lookup the time point (column A) at which the maximum force value occurs for each curve or if this is not possible the row number in which the maximum force value occurs. I would like to be able to do this using a formula rather than a macro if that is possible?
I have tried using a number of excels lookup functions and read through the examples on the site but have had no success.
View 3 Replies
ADVERTISEMENT
Oct 22, 2007
* I hav two columns B and N having some data. From column N i need to find the Maximum valued cell.
* And now i need the content of a cell in column B in the same row , which matches with maximum value.
View 2 Replies
View Related
Feb 9, 2009
I spent couple of hours trying to figure this out, but without success. Please check the attached example. I need a formula that will find the max value (number of views in English anguage) in the column "I" and display the corresponding "Headline" value in the column "B". In the example it is "Headline 5".
I can not change position of the columns, i.e. "B" must remain "B" and "I" must remain "I".
I experimented with Index and vlookup but to no success. I have outlook 2003.
View 5 Replies
View Related
Sep 11, 2012
I need to just highlight the maximum value in a column. This will be for several excel sheets within powerpoint, and preferably automatically updated?
Something along the lines of:
VB:
If
Ax = Max(A1:A3)
Then Ax = red
Else = white
End
View 1 Replies
View Related
Jul 9, 2006
I need a formula for Excel
I want column J2 to L2 to display the highest amount on colum M2 and add 2 to it.
I've tried some IF formula.
View 9 Replies
View Related
Oct 23, 2008
I was hoping that my formula would give me the count number based on the Maximum time (latest time) and the Name field...My result is a 0 instead of 62 (the correct answer).
=SUM((Download!$H$2:$H$10=A4)*(Download!$D$2:$D$10=MAX(IF(Download!$H$2:$H$10=$A4,Download!$D$2:$D$1 0)))*Download!$I$2:$I$10)
Would a Index/Match/MAX function be more efficient?
View 4 Replies
View Related
Apr 29, 2009
I would like to write a formula to have a result in a cell that gives me the maximum value of a column, but smaller than another cell.
For example:
C1 = Maximum value in column A1:A20, but smaller than B1.
View 14 Replies
View Related
Dec 26, 2013
I have this column [Status] in a table, as below:
Status
Budget
Scheduled
FY13
FY14
I want to get the maximum year value out of this column (in this case, 2014). What formula can I use?
View 3 Replies
View Related
Nov 21, 2006
Trying to grab the value to the left of the max value in a range of cells. Wasn't sure if I needed to use the offset function, I tried the vlookup function but the value i'm searching for is in the 2nd column, not the first. I can't download files at work, so if you could examine the example spreadsheet i uploaded, and then type the formula I should use in the post.
View 2 Replies
View Related
Oct 9, 2008
Look in Column E and find the MAX value. Once you find the MAX value, (let's say E27) display the date that's in C27. I bet this is really easy but I've been screwing around with it for over a half hour and can't get the correct result.
View 2 Replies
View Related
May 15, 2009
I have two columns of data. The first column is the 'type' and the second column is the 'value'. I need to find the maximum 'value' for each individual 'type'
The 'types' are not necessarily next to each other and the data cannot be sorted to do so.
Example:
type value
A 15
B 6
A 21
C 7
B 13
I need to be able to say the MAX for 'A' is 21, the MAX for 'B' is 13 and the MAX for 'C' is 7.
View 2 Replies
View Related
Jan 22, 2010
I am new to working with Pivot tables, and am working on a data set of survey results. We'd like to build a heat chart into the pivot tables for each column of data. To do this, I need to determine what the maximum and minimum values in each column are, and base the cell coloring on the difference between min and max values by quartile. Ideally, this would be able to update when the column headers change (from a list of departments, to countries for instance).
View 2 Replies
View Related
Dec 11, 2008
Say I have 2 columns that in basic form look like this:
Column A Column B
Jan 1
Feb 0
Mar 7
Apr 4
May 15
Jun 2
Jul 5
Aug 4
First I want to look up the max value in this column. This is easy =max(b1:b8)
Then I want to know the minimum value that occurs after the maximum value. Thus the answer would be 2.
View 3 Replies
View Related
Sep 16, 2007
In attached example, I have 3 columns of fractions with a final row of sumtotals (taken from elsewhere). I test to see which column has the maximum value in each row and allocate the result with the column's heading. Sometimes, two or more columns have the same max value. In this scenario, I wish to select the column heading that has the largest sumtotal.
View 4 Replies
View Related
Nov 7, 2008
This should be simple to do but I can't figure it out. I have a database that lists operating room numbers in one column and the length of the surgeries performed in those rooms in another column.
I need a formula that will give me the longest OR time for a given room. For example the room numbers are in column A and the OR times are in Column B. I've tried something like
View 6 Replies
View Related
Sep 24, 2013
I have trying to find the maximum date value in a series of campaigns with the same name [Combnined Campaign (Campaign)] , the aim is to pick the lowest version of the same name if the campaign is connected and pull the max end dates and number of weeks [Week Number Combined Campaign] that overall campaign has been running. A spreadsheet below explains this too.
What I need is to search for all the campaign names in column [Combined Campaign (Campaign)] and find the matching week number. What I am currently using is this formula:
=IFERROR(IF(E2="Yes",INDEX($A$1:$K$26,MAX(MATCH(F2,$G$1:$G$26,0),1),COLUMN($K$1:$K$26)),""),"")
Yet Max doesn't work with text.
Campaign Appeal Code
Launch Month
Market
Product
Combined Campaign (Yes/No)
Combined Campaign (Campaign)
Channel
Start Date
End Date
Week Number
Week Number If Combined Campaign
AAB13
Jan
Yes
AAB13
Mail
01/01/13
31/01/13
Complete
[Code] .........
View 2 Replies
View Related
Jan 2, 2010
I have a got a table ( 10x30) with random numerical values.
How can I return a column number with maximum value?
Values will be changed periodically so the maximum number could be in different column each time
Example:
A-B-C-D-E-F-G
1-2-3-4-5-6-7
2-6-8-18-1-1-8
2-5-6-9-12-1-7
The results will be 4.
View 9 Replies
View Related
Dec 31, 2013
I'm developing a spreadsheet for a nonprofit that provides feedback on their major fundraiser/auction. I'm trying to create a formula in a cell that will look at the bidder #'s in column B and add the value of the their purchased items found in column C and return the number of the bidder that has the largest total value of purchases.
This can be done with a pivot table and give a table of all bidders, their total amount paid for items, and the number of items purchased.
View 1 Replies
View Related
Apr 28, 2013
I am using Excel 2010
I have over 800+ pages of chart that only takes up 6 columns and around like 9000+ rows.
I wanted to print this chart on paper and need hardcopies. However, the chart in its current setup prints only on the left half of the page leaving the right half empty.
How do i make use of the full space properly? Each chart has a "page number" on it so I want the chart to print continuously from one half of the page onto the next half and then the second page, third, etc.
Here is a visual demonstration of how things currently are and how i'd like to get them to be:
As you can see, This is the first of many charts and its numbered Page 9 and next one is page 10.
Pic1
How this looks when i try to print, it's only on the left side. right is all blank
Pic2
How i want it to look like upon printing
Pic3
As you can see in the last picture, once page 14 chart has no space it automatically continues chart on right side of page and then moves on to print rest.
[URL]
View 7 Replies
View Related
Feb 4, 2009
In a cell, I would like to limit the maximum upper limit. For instance, in a cell with (=H23*0.06), that value ranges from perhaps 1.48 up to 5.93; however, I would like for the upper limit to stop at 3.33. Would that be conditional formatting? How can I stop the upper limit at 3.33?
View 2 Replies
View Related
Nov 18, 2007
I am looking for VBA that will add the value of the current active cell on the sheet to the value in cell F12. The maximum value of F12 cannot exceed 1000. So if the value in F12 = 950 and 100 is the value in the active cell the maximum value in F12 should show 1000, not 1050.
It should do this on the click of a button.
View 5 Replies
View Related
Nov 13, 2008
I need to limit the number of letters that a person can write in a given cell.
View 5 Replies
View Related
Dec 26, 2006
I have a worksheet that multiple users will be entering in data, this information is then being used to pull into a form located on a sepearte worksheet within the workbook. One of the cells in the input sheet has the potential to have more characters than excel will allow. It is my understanding the maximum number of characters per cell is 1,024.
What is the best way to setup my spreadsheet in the event the data contains more than 1,024 characters. The informatino going into the cell are legal descriptions of property so I want to be able to keep the description together in the final document in the other worksheet. Is there a way the user can input the entire decription in one cell, regardless of the character size, then have a formula to take the first 1,024 characters and put them in one cell, followed by another formula to put the next 1,024 characters in the next cell?
Then in my main document I would use the concatenate formual to combine these two cells into one.
View 9 Replies
View Related
Nov 21, 2007
[TABLE]
item01/11/200702/11/200703/11/2007
a1710
b2611
c359
[/TABLE]
I have the above table. I would like to determine which is the item that has Maximum value on a particular date. example on 2/11/2007, the maximum value is 7, so the result should be item a. How can I achieve this by using a formula.
View 2 Replies
View Related
Jan 31, 2013
example.png
I am sure this is simple and easy to do, but i am having difficulties achieving this.
I want the cell to fill as it gets closer to 100%, I am sure its conditional formatting but I cant seem to get it to work.
View 1 Replies
View Related
Aug 29, 2005
I'd like to have the cell address returned along with a value when I use the
MAX function.
View 13 Replies
View Related
Feb 12, 2007
I have a range of overtime data. I want to list the maximum occurrence of first 10 overtime data ( Like 3200,2950.2300....etc) Thereafter from the results obtained I need to know the cell address of the employee corresponding to the results obtained, i.e XYZ, ABC.....
A B
Employee Name OT Amount
1. XYZ 3200.00
23. ABC 2950.00
35. WER 2300.00
View 10 Replies
View Related
Oct 15, 2008
What formula can i use to obtain the address of the cell which contains the highest number? My range is A:A
View 2 Replies
View Related
Jul 10, 2012
I am trying to return the value in the cell immediately to the left of a Maximum value found in 3 cells. I've added the MAX(Q4,S4,U4) formula into AF4. I've tried several variations without success.
View 5 Replies
View Related
Nov 20, 2007
If I have a column full of data (call it 5000 data points) and use =min(a1:a5000), how do I find the cell this function is referencing without sifting through 5000 entries?
View 6 Replies
View Related
