maximum

  1. G

    How to find the 2nd largest value in a series of data that may contain multiple incidences of the same value?

    Hi, I am trying look for a function or a solution to finding the second highest value in the array of data that may contain multiple instance of same values. for example: array = [31,28,31,27,28,29,26]. The LARGE function couldn't help me because if I pass arguments like LARGE(array.2) it will...
  2. P

    Extract min/max values from a range of cells which share the same day

    I have 3 columns: "A" contains the day, "B" contains the hours, and "L" contains some values. For each day, there are 24 hours and these are associated with either negative or positive values. I would like to extract the minimum and maximum value of only the positive values (i.e. >=0) from...
  3. G

    Reverse VLOOKUP....Is it possible??

    Hi, I would like to find a data which is in the left side column of the lookup data. EXAMPLE Col A Col B Col C XYZ 123 12.3% ABC 345 15.2% EFG 105 10.3% I would like to pick up the data in col A for the maximum...
  4. S

    How would I go about determining all potential costs from each scenario to maybe index the invoice and see if there is a match?

    I was given tens of thousands of bills charged to customers. I am trying to determine if the bills are potentially accurate. The only data I have is the actual bill itself. Here's where things get complicated. There are four scenarios, each with their own nuances: Scenario 1 Nuances: 1. Base Fee...
  5. H

    Code needed for Max & Min Values

    I have B2:B10 which are dynamic cells & keeps on UPDATING (based on time criteria) Corresponding MAXIMUM & MINIMUM values required in E2:E10 & F2:F10 Code required to accomplish. I am using Excel 2007. Thanks in adv. Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col...
  6. Mackeral

    Problem changing For Loop Maximum inside the loop

    Consider the following code: Last = 10 For I = 1 To Last Last = Last + 1 Next I At the end of the code you find I = 11 and Last = 21. The implication of this is that once you set the Maximum for the loop, you can't change it. So you have to use a Do While loop explicitly...
  7. R

    Simulation Computation

    Hi guys, hope you can help me out. I am trying to build an emergency fund simulation. Total monthly expenses value is equal to the value of P28 on "Cash Flow" tab, Cash on Bank is equivalent to F8 on "SALN" tab. Recommended funding multiplies the value of the monthly expenses by 3 and 6...
  8. S

    Error when posting - Number of tags exceeded maximum amount

    Hi All Trying to post a question and I have included two tables, but for some reason I get the error message "The number of tags you tried to add exceeded the maximum number of tags by 1" Is there anything I can do to fix this?
  9. B

    Thread Tagging Improvements

    1. The webmaster needs to code a control in the "Tags" field that COUNTS the number of characters being used up and display the number of characters dynamically AS WE TYPE to help us optimize the words we choose when creating a NEW Post. Also, switch the characters to the color RED when we've...
  10. A

    Using Excel Solver to find three parameters from MLE

    Hi everyone, I have a question regarding the use of excel solver in maximizing a cell with three parameters. I am trying to solve a three parameter maximum likelihood in excel. However, every time I tried to solve it, excel said that the solver encountered an error value in the objective or...
  11. C

    Combined Spin Button Maximum

    Hi I've been asked to create an interactive worksheet so that users can use "sliders" (by which I'm assuming spin buttons or scroll controls) can distribute £60,000 across up to 6 different sectors, one 'slider' per sector. I have: Cells B1:B6 linked to spin buttons 1-6 The £60 (I shrank it...
  12. B

    minimum maximum value formulating

    I am trying to put a corresponding value in a certain cell from a value in another cell. It will require me to do a "if this number is between two numbers in two columns" then it states the value to be inserted in a certain cell. I am having a problem figuring out what kind of formula to use...
  13. P

    hello, generate all the formations of the 3 letters .

    hello, generate all the formations of the 3 letters in the following criterion = no more than 5 letters for each of the 3 lines a = 01 02 03 04 05 06 07 08 09 1 0 b = 11 12 13 14 15 16 17 18 19 20 c = 21 22 23 24 25 26 27 28 29 30 31 So the formations will have 7 letters the maximum...
  14. R

    I am trying to add exceptions to a formula

    Dear Sir or Madam: My name is Robert, and I have just one more Excel formula issue before I fall asleep. The following formula works perfectly, but I want to add exceptions to it. I need Excel to find a cell that contains "minimum", "maximum", and range" with any other words except the...
  15. C

    Need Formula For Maximum Skips

    https://app.box.com/s/f3iwju014t1h01kphthqslln68zo1scq The top box tracks the number of times a value has followed another value.The values in the lower box are the skips. Skips are the number of draws since it was last hit. I would like to add another box to track the maximum skip in all draws.
  16. K

    Count Maximum Days Based on Status

    Hi, I have three columns. Column A has the task type , column B the number of days and column C has the status as Completed or Pending. I need to show the maximum days pending for any task that has been tagged as Pending in column C. I am using the following formula but it does not work...
  17. Y

    Macro to calculate values to hit a certain limit / target

    Hi all, Per below example, how can I design a macro that when clicked, will calculate the values in Column D, such that the current percentage reaches 50%. In below example, to achieve 50%, the sum in Column B should be 15/30, meaning I am lacking 6 hours (from the existing 9 hours). The macro...
  18. S

    look up maximum date and state

    Hi I need a formula to look up maximum date and corresponding state In below case it should look at state , eg VIC and also maximum date 04/01/2019, giving answer 50 <colgroup><col width="64" style="width: 48pt;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt...
  19. A

    More than 255 series in a chart (sort of)

    Hey guys So i know that 255 is the maximum number of series that excel can plot. However would excel be able to plot more than 255 series on a graph but only having 7 or so displayed at one time? I am trying to make a dynamic chart that changes what series are plotted based on different...
  20. W

    Sum points awarded if its applicable if not replace with maximum score

    Hi All, I've developed a spreadsheet which is an audit document however some sections are not applicable to some sites. My issue is that because the questions are not applicable, I don't assign a score which results in a percentage score of 0%. This has a negative impact on their overall score...

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