max value

  1. S

    Cut Smaller Pieces From Bigger Pieces

    Where I work, I take large remnants of raw material and see if I can cut them down to smaller pieces so we have less waste. I've created a few spreadsheets that allow me to do this a bit more efficiently. Once I've decided which piece to cut, the meat of the operation lies in being able to get...
  2. M

    How to find the MAX Value in a range defined with R1C1?

    Hi, I'm new to VBA and this forum, so sorry, if this is a stupid question. I' trying to write a function for a university project. In this function there's a situation where I want to define a range with using R1C1 syntax. I don't want to use smth like "A1:B1" since the range is dependent on...
  3. A

    Get MAX value and Other Value based on Criteria

    I have a table (pasted below) showing COMPANY, BRAND, VALUE. I am trying to put a fomula in E2 that looks at the company name in E1, then looks in the table and picks the brand AND the value for ONLY the MAX for the company in E2. So, E2 should come up with BRAND3: 30 F2 should come up with...
  4. S

    Return max value based on criteria

    Hello guys, I am trying to get the max value based on the supplier's name and their (max) score that I have in a list. in short: I have a list of suppliers (column A) to which I assigned a colored zone (B) and a score (C). Based on the supplier's name I would like to return the highest score...
  5. H

    Vlookup Max Value

    Hello, I am trying to look up the Max Value (Paid Rate) from one sheet and return it to another sheet. I have employees that are paid at a Base Rate, but sometimes are paid at a different rate. On 'Orig' Tab there can be a lot of Rows for employees and I need to find the MAX Paid Rate in Column...
  6. A

    Macro for Max Value, convert to value

    HI I created a excel spreadsheet full of formulas to automatically update for reporting purposes. There are a 2 sheets in my excel file where i would like to; 1) Sheet2 (45 Degree Data) Find the date max value between B6:B50 2) Select the max value row and convert the content in values (for...
  7. 2

    Macro for finding and copying the max value in a column

    Hello, I am looking for a macro that will find the largest value in a column (e.g. C36:C101) and then copy that value into a new cell (e.g. D62). As I am very new to VBA any help would be appreciated.
  8. M

    Row & column number of max value in an array

    This is probably quite a common question but I can't find a suitable answer on the internet. Every time I create an array of probabilities I need to record the row and column number of the max value. An example of such an array is below: <tbody> 11 7 3 1 0 17 11 4 1 0 13 9 3 1 0 7 4 2 0...
  9. T

    Setting ScrollBar Max value from Cell

    I have an ActiveX ScrollBar and want to set the Max value to the contents of an Excel Cell so that it becomes variable. What is the VB coding? So far I have: Private Sub ScrollBar1_Change() Dim cell As Integer cell = 200 ScrollBar1.Max = cell End Sub Which works. I now want to change the '200'...
  10. I

    Find max value from 5 non-continguous columns

    Is there a formula to find the max value from columns C,G,K,O,S and put the value into column W for the example below: C,G,K,O,S ARE THE Term columns FIRST ROW: 1122, 1125, 1112, 111,1107 ( I CANNOT GET THE COLUMNS TO LOOK RIGHT WHEN I PASTE THE EXAMPLE) C G...
  11. A

    VBA Help: Finding Max of a range and pasting in another sheet

    Hello, I'm trying to compare 5 items in a pivot and then finding the max value. Whichever is the max value will filter the next Pivot. As of right now I have a super long code that works but I was wondering if someone could help me condense it a little. There are 2 pivots exactly the same; one...
  12. E

    Complex Index Match Max return date and label formula

    Hello Excel Gurus, I have a problem that has been stifling me for the past 2 weeks. I have a data table that includes a primary product and its components i am trying to forecast for completion within a set of 30 day periods. The components must complete first within enough time to complete the...
  13. V

    Selecting from a table to enter a max value in another table

    I have two tables and would like to look at values assigned to categories in one table and in another table, only populate the largest value to the same category. For example: Table1 has the following categories: 1 2 A Apple B Boy C Cat D Dog Table2 has the same categories with...
  14. PoggiPJ

    Array Formula for Max Value with Conditions

    Originally I only needed the latest date in a list - simple, Max(A2:A7). Now I need to only consider end dates where the Extended Total is >0. I understand the basics of how array formulas work and have written some simple ones, but I am struggling with an array formula that will give me the...
  15. J

    Max Date Lookup with Multiple Condition Criteria

    Hello, I have two tabs on my excel sheet, one is the summary and the other tab is the data tab. I need to find the most recent date for the "State" and "Store" combination where a sale occurred. Example: PA had a most recent sale on 1/21/13 in Store 20 NY had a most recent sale on 1/22/13...
  16. E

    Simple question. How to find max value in a cell that is constantly changing (due to recall function)

    Hey cell ac1 has recall function in it. The value in the cell changes every few minutes. The formula in ac1 is the following =if($m$2<0.88125,if(customer!$h$5="",$ac$1,recall()+(billing!$y$7)),0) the recall function adds the present value in ac1 with the value in y7. Now if the 'if'...
  17. L

    max value in array problem

    Hi All, Does anyone know if there is a bit of code when working with arrays that tells you the maximum value in an array (similar to Ubound), without having to loop through all of the values in the array until it finds the max value. I don't have a problem with looping through the array, but...

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
Back
Top