maximum and minimum

Could anyone help me with the formula for below problem. I need to find the item name with the maximum price in a new column against the name. Attached the excel for the reference. CDEFG1NameItem NamePriceExpected ResultFormula to be used using...

Hi all, I have a cyclic data sheet from where I need to get only the peak value in each cycle. Here's a sample of the data. I have filtered only the positive part here. Same needs to be done for the negative cycles. Any help on the matter is highly apppreciated. Thank you

Hi all! I currently have two columns, each with fractions in them. They are visual acuities for the right eye and the left eye (the fraction that shows how good someone can see in each eye...e.g., 20/20, 20/10, etc.). I am trying to find a way to enter the maximum between the two cells into a...

Hi, I am not very good with VBA but, I'm trying to change the Y Axis to a value in a cell (basically i'm trying to tighten up the auto setting). I would also like it to only happen to a specific chart (Chart 45) every time the cell changes. I have managed to find some code that I think may work...

I am sort of new to excel so this is probably an easy question but can't get my head around it! I am working on building a Dynamic Dashboard and want to people able to type in a metric (or pick from a drop down list) and have the dashboard show me the top 3 performers based on max (the names...

Hi, This is my first post here (though I have read the forums for resolving my earlier doubts). As a sample, I have attached screenshots of the 2 sheets of data. I am trying to find maximum value of Profits in each year 2008, 2009 & 2010 (Columns B, C & D) for each unique item (Column A)...

I am using a simple formula in a cell like below and have the cell formultated to calculate as a percentage. =WKSHT2!D136/WKSHT2!C136 But i want to make sure that if the returned answer is over 100% that what displays is "100%". In other words I want the max answer to be 100%. How do I do...

I need some help with this. I have a massive amount of data, broken down in columns. Each column contains a different set of values, pertaining to a single text value in another column. For example: Column A (going downward): A, A, A, A, A, A, A, B, B, B, C, C, C, C, C, etc. Column B (going...

Hi everyone - huge thanks in advance to anyone that can offer some assistance with this problem. I have a 6x5 matrix with a series of data in it. It is as simple as this: Row 13: 0 1 2 3 4 Row 14: 0 1 2 3 4 and this is repeated over for 6 rows. The figures in each cell can increase or...

Please help! I am working in table 1 to fill-in “Index A” with data from “Index B” of my “Lookup Table” by finding which range (Max:Min) covers the “Value”. As an example, B2=Lookup Table: C2=31 as 17950 is within A2 and B2 of lookup table. Table 1: <table class="MsoNormalTable"...