maximum and minimum

1. Finding maximum value against a value using vlookup

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...
2. Finding peaks in cyclic data

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
3. Finding Maximum/Minimum fraction between two columns

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...
4. How to set the Y axis using VBA?? Help

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...
5. Ranker of Maximum Values on Changing Metric

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...
6. Maximum & Minimum values - filtered ranges across sheets

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)...
7. Limiting Results to a maximum # of 100

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...
8. Help with finding the maximum value between variable ranges

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...
9. Excel 2003 - Maximum Percentage formula...

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"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back