max based on criteria

Dear All My data set is given below. I want to get the maximum value for "Package 1" highlighted in RED, BLUE and the middle column is just BLACK. So the output should be 0.69, 0.59,0.96. There are other packages too. The next one is Package 11+14, for that the answer I want should be 0.54...

Hi guys, can you help with formula? Below is a list of Customer transactions & their values within Industries. Formula should Sum Up Prices in Industries for each Cust ID and return name of Max Sum Industry into Leading Industry. <tbody> Cust ID Industry Price Leading Industry 5...

Hi, I need to reference the specific site name on column B, find out which entry for that site is the most recent from column A and return the value in C (whether it is "cleared" or "raised"). There will be duplicates in Column B (Source) but I am only interested in what the most recent...

Hi! I am trying to make a formula where the longest word in a range from a different worksheet, is reflected in the same cell where I create the formula. For example, Cell A4 should have the formula and the Range would be located in a Worksheet labeled Descriptions Cell A4 would show the...

I am trying to find out the maximum and minimum values in Index and Match function For example Nodes Sign Moment 1 +ve 54 1 +ve - 10 1 - ve 68 1 - ve - 15 1...

I'm going to give the long explanation as this is confusing me - my apologies. In a workbook I have a client name in column A. I am trying to lookup this name (minus last character) on my "Evidence" sheet. I want to return the data from Column L on that sheet, but if the client name is...

I have a time sheet Table that I pull from Share point and it's linked. to fill the table I have 4 criteria that must be met .Any formula I use It gives me zero result and don't show me the actual Time in the time sheet. Can you help me? Employee Name Sales Manager ClockType Date...

Hello everybody, The excel must obtain the max value of a list of values, the range of values where it looks change depending on a constant. Exercise: a list of 30 random values in column A; on C1 a "constant" like 3, 5, 10, 15. On column B the MAX value of 3 (A1:A3), 5 (A1:A5), 10 (A1:A10)...

Hello, I'm trying to generate a lookup that would return a value in a column based on several criteria and the SUM MAX of two figures. Been using INDEX(SUMPRODUCT()) for all of my lookups up till now, so thinking it may be just a matter of appropriately nesting MAX, SUM, SUMPRODUCT, and INDEX...

Hello! I am trying to do a scheduling formula wherein I have a block of cells which will become my start date. If I didn't have a constraint, the rows above these dates will simply be date+1. However, I can only schedule a maximum of 4 things on a given date. So, I need a formula that will...

I am having difficulty trying to get the max closing reading from this table. I can get the min value using =MIN(VLOOKUP(E2,A2:B10,2,FALSE)) it brings up the 1st entry no problem. But I tried the same formula with =MAX(VLOOKUP,E2,A2:B10,3,FALSE)) but it brings up the closing reading for the 1st...

I wanted Column E of my dataset to read "Max" for the row where the ID contains the max probability for that state. If two IDs for the same State have the same probability, as in Maryland, I wanted "Max" to show for the ID with the minimum Date. If two IDs match on both Probability and Date...

I am having a problem coming up with a MAX function that will return the last date in a sequence. I have tried the =MAX(IF($A$n:$A$n=An,$B$n:$B$n)) function, although it returns the MAX date in the entire list rather than just the highest number date for the given unique ID number. For...

Using countif, I know how to count how many cells are greater than a specific number, or another specific cell in a set of data. But I dont know how to do that or a range of data. I'll put an example to make myself clear: <tbody> A B C D 1 171 3 0 1 78 3 3 0 132 6 1 0 2 55 65 1 30 45...

I am comparing 2 sets of account balances and want to find the account with the largest change in balance from day to day for a specific product category (Personal Accounts) and location (10). The accounts are separated into groups by a product code and location ID. Below is a data sample...

Hi, I want to show a maximum value of an array (of dates) based on a combination of two criteria (a kind of 'MAXIFS' function). My data is a bit like this ... <tbody> A B C 1 Date Criteria 1 met? Criteria 2 met? 2 01/03/2015 y y 3 15/06/2015 n y 4 21/06/2015 y y 5 08/01/2016 n y 6...