max function

I would like to find the largest value across multiple sheets and return the sheet name where the value is located in. The issue is that each week a new sheet is added so I can't create a static list of sheet names. The data are located in the same cell across sheets in cell B10. I have hidden...

Dear VBA Experts, Excel newbie here I could really use some help with thi piece of code I´can´t get to function. I want the colour of row "x" in column "K" to change given a certain value of ro "x" in column "G" AND a maximum value in row "x" in columns H-J. Here is what i have come up with...

I am copy some data from one worksheet into a master worksheet (same workbook). The master worksheet has a unique ID (next number). After I copy the data over the master worksheet, I would like to fill in the ID. What I need the macro to do is fill in the missing ID numbers to the end of the...

Hi all - thanks for a great site. I have an unresolved issue using MAX function that has multiple and identical hits. If anyone has a tip or formula for my issue I am grateful. My data (two columns) <tbody> Customer ID Customer age 1 66 1 65 1 66 2 27 3 58 3 62 </tbody>...

Hi, I need to use this formula, but use it within a Table that grows. In other words the array will become larger. I hope you can see what I am trying to do with this formula and I hope someone can show me how to recreate it for use in a table in stead of a Data set. Is there a way? If so...

Hi, I have the following data set where I have three columns: Name, Date and ID. I am trying to identify the latest date against each name and in some cases where the dates are duplicated (as in case of John, 15/05/15) I want to be able to identify the name against latest date and highest ID...

I built a formula to retrieve a date from a list. {MAX(IF(AM2='POs Recpt Date '!A:A,'POs Recpt Date '!E:E)} <colgroup><col><col><col><col><col></colgroup><tbody> PO Value DC PO Vendor PO Date recvd $18,022.20 LIV 217550 XXX 1/0/1900 $19,050.00 LIV 217603 XXX 8/7/2015 $19,050.00...

Hello, I am wondering if there is a way to find the max of a range using VBA, I have thought of using the "max" worksheet function, but the problem is I have a range where the numbers are stored as text. I could convert the text to numbers and then run the max function but I would like to keep...

Hi all, Below is the part of the dataset I have. As you can see, there are 4 columns: Model, Sequence, Applied Date, and Expected Cost. Each model has different sequence numbers and each sequence numbers have different expected cost. What I want to do is to extract only one corresponding...

I got stuck on the formula to find the value of a cell, based on two conditions. column A has location, column J has number of days. I now want to find the name with the highest number of days for each different location from column S.(rows in between do hold data, but are not relevant for thuis...

Hello, I am having a bit of difficulty and need some help with the following I have 3 sheets called Data-2013 Data-2014 Data-2015 These sheets contain weekly performance data for the designated year and the each row holds the same data, i i.e. row 2 = 'widget sales' row 5 = 'sproket sales'...

Hi Ive been struggeling with a problem for some time now, which should be rather easy to solve but excel is not cooperating with me. I´m making a worksheet where cell "A1" should show the last time an action have been made. This should be found in another worksheet where date and time for...

Hello, I have been searching for a solution to this with no luck so will explain my problems here: I have three worksheets relating to three football teams. On each of these worksheets, B2:B19 contains the names of the players and C2:C19 contains the number of goals that each player has...

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

I am trying to create a formula that will display the 'name' from column A that corresponds with the row of the value resulting from Max function for range in column B. To illustrate the desired results: On 'sheet 1' I have the max function determine that cell B5 has the highest number for...

I am trying to create a formula that will display the 'name' from column A that corresponds with the row of the value resulting from Max function for range in column B. To illustrate the desired results: On 'sheet 1' I have the max function determine that cell B5 has the highest number for...

Greetings,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am new to this forum and this is my first problem to address. I have problem with the below formula. It is supposed to show the last column used in the sheet, i.e. last column with...

In the below example table, I have 4 columns of data, Label Name, Size, Amount and Location. I am trying to come up with a formula to get the maximum size of the Amount column (column C) when the Label Name (column A) and Size (column B) contain a certain value and the location (column D)...

Hi there, I need some help please! I'm linking with another document to find dates for when people need to attend refresher courses. The other document was created by someone else, and I don't have permission to modify the other document to change the format of the dates, so the dates that...

I am using a max function to find the max of an array found by multiplying two conditions to arrive at a single array: =MAX((Data!$B$3:$B$202=Analysis!$B4)*(Data!F$3:F$202)) where the first condition is used as a true false (1 or 0) to only count the following condition when it is met. It...