max based on criteria

Trying to figure this out and it’s probably something quite simple. Layout: I have a running log of information and events that are entered in with dates and times. From this I have a table using COUNTIFS formulas set to count the number of times certain events take place during each 8 hour...

I would like use a vlookup or equivalent to pull the latest comment for a specific ID. I can’t figure it out. I’m thinking maybe MAX but I’m not using it correctly. I think i need the vlookup because I am filling in cells in another table with the latest comment for its ID. In this example I...

Hi, I currently have this formula: =TEXTJOIN(",",,FILTER(TEXT(Daily_Data!$C$5:$C$5000,"dd/mm/yyyy"),Daily_Data!F5:F5000=LARGE(Daily_Data!F5:F5000,2)))&"." Now this works fine, in that it will return the dates for the highest number in column F. What I'm after is to have the value of...

I have the following dummy table. Value of Header1 will be in cell A18. Value of Header2 will be in cell A19 and value Header3 will be in cell A20. I have about 20 headers and I want the highest number in the range based on what is in the relevant cell. The order of the headers may change, so...

Hello, I've been searching and trying different formulas for some time and to no avail. I want help with a ROUNDDOWN and maybe a MAX formula to calculate tax. So basically, the first $2,000 is taxed at 10%. $2,000.00 is the max that can be taxed at 10%. e.g. if the tax overage is $1,500, then...

Hello all - In Excel O365, I have a table that has data which starts in row3. (Row 1 and 2 are headers) In col HJ (starting with HJ3), I have formulas that return "W", "L", or "". (So Win, Loss, or Blank) In col JS, I have formulas that check if HJ (is a "w". If it is a "w" the formula...

Hi, I have a dataset where it has a Date field and there are 4 or more than 4 'Resource Name' columns. The name could be repetitive in each column but it will not be repetitive in each row. Now, I have a list of unique resource name and I need to find out the max Date for a particular resource...

Hi, I have a data set where randomly things have strikethroughs in it due to errors in that data collection. The strikethroughs are put in manually. I'm trying to figure out how I could code a max of a set of 10 numbers excluding the numbers that have had a strikethrough applied to the set of...

Hi I need the formula for max frequency or similar to this, Problem statement is - I have an attendance record of 1 month in which I need to calculate a repeated occurrence. let's say.. if Mr. ABC is present (P) from 1-April to 7 April, and then on his Week off day he was present then the...

Guys I have the following problem. I need to identify if the date of the record is the earliest date of the group. The idea is NOT return an aggregation table, the idea is return all the records but in a custom column I want to identify if the date of the record is the earliest of the group. If...

I have an excel document which consists of two array. Left Array consists of 4 rows which have values from 5-1 (5 beings the highest and 1 being the lowest). The values A,B,C,D,E,F are simplify reference points. W Right Array consists of the cells that corresponds to the cell from the Left...

Hi all, So this one may be a bit confusing to explain so I'll try my best! I'm on O365. I have a table, which will grow by rows as time goes on. ID1 ID2 ID3 ID4 ID5 ID6 ID7 ID8 1 2 aaa bbb ccc ddd 100 100 2 2 eee fff ggg hhh 400 400 3 3 iii jjj kkk lll 700...

Hi, I'm new to this forum. I have an excel sheet with over 2000 rows. I want to have the maximum number of the Quantity of each item Code when the location is the same. For example, you can see in the excel sheet i have the ItemCode : 389-12-040 1107 01 4.00 1 1107010 A 389-12-040 1107...

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 everyone, In a table i have : E1= Apple; F1= 0.2%; G1= 1.5% E2= Banana; F2= 1.5%; G2= 3% E3= Pear; F3= 1%; G3= 4% E4= Cherry; F4= 4% ; G4= 10% E5= Peach; F5= 5% ; G5= 20% Column F represents the minimum % and column G represents maximum % In A1 i have a data validation drop down list...

SUM OF MAX CONSECUTIVE FREQUENCY OF MATCH OVER MULTIPLE COLUMNS WITH MULTIPLE CRITERIA I wish to solve for the sum of the maximum frequencies in multiple columns with multiple criteria, using a formula that will prevent errors. IF D9="","", SUM MAX FREQUENCY IF D9 matches...

Im trying to get the Max value from the longest wait time for the month of Jan, Feb and Mar.i tried using =max(if($c$c="Jan",$h$h)) but it wont work, can someone help me please? thank you so much. SkillGroup Year Month Day Total Inbound Calls Total Calls To Queue Total Calls Abandoned In...

Dear Friends and Respected Seniors, i have this data in sheet2 starting from cells a1:b9 <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> a 8 b 5 c 2 h 4 j 3 k 85 y 65 u 47 i 11 </tbody> I want to...

Hello, I have 4 columns of data, like this: <tbody> NE NW SE SW Prevailing 45 30 22 31 NE 25 59 51 42 NW 71 44 21 18 NE 9 5 22 56 SW </tbody> The first 4 columns contain numbers of wind data. In the fifth column I want to write a command, by which the name of the prevailing wind...

Hello guys Column A has the marks obtained by the students whilst column B has the name of the students. Two student have scored the same highest mark. Now I want to know how can i find the name of the two students who have scored the same highest marks. When I use...