minimum

  1. C

    How to find minimum value in a grouping of rows

    Hi, I have a grouping and subgrouping of rows in my worksheet and I want to use the minimum value from each group and subgroup and use those values in a report on a separate worksheet using vba. Here's the situation Emp List (Column)__________________________ Salary - Workers __+ Foremen __-...
  2. C

    Minimum Value in a Grouping of rows

    Hi, I have a grouping and subgrouping of rows in my worksheet and I want to use the minimum value from each group and subgroup and use those values in a report on a separate worksheet using vba. Here's the situation Emp List (Column)__________________________ Salary - Workers __+ Foremen __-...
  3. S

    Conditional Minimums

    Hey everyone, I am trying to set up a conditional Minimum formula. On Sheet 1, I have 1000 IDs split into 20 different groups all on one rolling list. So Column A has all of the IDs, Coulmn B has the group name they are in, and Column C has the values of each. On another sheet (Sheet 2) I have...
  4. J

    calculate minimum value with 3 conditions

    Hello - I'm trying to calculate a minimum value from column J when data in column E meet one condition (="1") AND data in column I meet one of two conditions (="E" or ="_"). I can calculate the min using the two conditions in column I, but not when I try to incorporate column E. Formula for...
  5. J

    Formula Help - MIN/MAX and IF

    Hi all, this one is starting to do my head in. it was working fine until they decided that there would be a one-to-many relationship in my mapping table. New table: Linked_ID is fed via vlookup, and looks up the ID of the parent ID. It used to lookup the child of the ID (since it was a one to...
  6. B

    VBA GoalSeek Comparion

    I'm relatively new to excel and have been having an issue with some vba in this model i'm working on.... Essentially I want to run 3 goalseeks on the same dynamic variable (L63) and return the minimum value goalseek finds. The following are the procedures for each goalseek: <!--[if gte mso...
  7. G

    Returning the smallest difference

    Hi I have the following data: <table border="0" cellpadding="0" cellspacing="0" width="745"><colgroup><col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="width:48pt" span="6" width="64"> <col...
  8. K

    Index table and return minimum between set # of periods

    I have a table with five columns. The first column is dates(months) and then there are four columns of product prices. I want to index the table by date and product and bring back the optimal (minimum) price in the 3 month period including the current month and the previous two months...
  9. V

    how to catch minimum in column with same condition

    Dear, I need to catch a minimum value from a column with same condition. For example. A B C 123 0.5 0.5 123 0.8 0.5 123 0.6 0.5 123 1.0 0.5 124 0.3 0.3 124 0.5 0.3 124 0.6 0.3 124 1.1 0.3 Below example, Same condition: A Value: B I...
  10. N

    Conditional Minimum and Maximum

    Hi :biggrin: , I use countIF, averageIF and sumIF a lot, and I want to do the same with Min and Max (also Mean and Median if possible), how would I do this? :confused: Example: Day Rating Month Year 1 5 Jan 2007 2 3 Jan 2007 3 4 Jan 2007...
  11. D

    Limiting multi-select listboxes

    I have a mult-column listbox where I'd like 4 items to be selected before it can be accepted. Is it easy, or even possible to limit a multi-select listbox in this way? It would also be great if a minimum number is possible (separate option). Many thanks David
  12. J

    Validatidating if a value is a multiple of another value

    I'm trying to build a simple order entry screen. I have an Item Table with a field representing the minimum qty that can be ordered for each item. In the order entry screen, I have a field to enter the qty the customer orders. I need a code to validate or automatically change the qty ordered...
  13. F

    Charts - Using a variable to set Min/Max Axis Values

    I'm sure this is either easy or impossible. My level of skill is good with Excel, very low with VBA. I'd like to create a chart, and use a variable or name to flexibly set the minimum and maximum values for the X and/or Y axis. When I try, I get an error message that says "Your entry can not...
  14. A

    Updating maximum and minimum values from a different sheet

    I have three columns (H, M, and O) that record the current value of a stock, the maximum value it reached since bought, and the minimum value. I want column M and O (max and min) to update to reflect changes in column H. If column H ever rises higher than column M, I want column M to update to...
  15. S

    Minimum 10, Maximum 10 from a series

    Hi there, I have data whereby I would like the sum of the top 10 numbers in a row and the sum of the bottom 10 numbers in a row. I have done this before by adding another row with ranking and then doing an If statement referencing the ranking. I want to do this operation, however, over many...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top