maximum and minimum

  1. T

    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
  2. K

    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...
  3. B

    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...
  4. E

    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...
  5. N

    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)...
  6. B

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

    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...
  8. A

    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...
  9. P

    Please Help!

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

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top