maximum and minimum

  1. 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...
  2. 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...
  3. 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...
  4. 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)...
  5. 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...
  6. 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...
  7. 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...
  8. 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"...

Some videos you may like

This Week's Hot Topics

Top