1. 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...
  2. 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...
  3. 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...
  4. M

    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...
  5. 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...
  6. 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?
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. C

    Need Formula For Maximum Skips 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.
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. Y

    OFFSET and ADDRESS trouble

    I have a table starting in A6. I have date and times in column A and numerical values in column B. I want the date and time of the maximum value in column B. To do this I have =INDIRECT(ADDRESS(MATCH(MAX($B$6:$B$36000),$B$6:$B$36000,0),1)) This gives me a date/time that is 5 rows out from the...
  20. T

    Pivot table - percentage between 2 columns Max

    Hi everyone ! I come for your help on Pivot tables. So I have done a pivot table, which depicts the maximum of a value on a specific date, for several parameters. See image in this link: So I have the Max values for X and Y on...

Some videos you may like

This Week's Hot Topics