max value

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...

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...

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...

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...

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...

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.

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...

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'...

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...

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...

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...

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...

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...

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...

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'...

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...