maxifs

Help please. Looking for a formula to define col D. I want to know the latest known 'Value' from colC (where it is not 0, UNLESS there is no other value). Grouped by 'ID' (ColA), and ordered by date (ColB) To get the latest date I can use "=IF(MAXIFS(B:B,A:A,A2)=B2,"Current","")", but I need...

Hi Everyone, This has been stumping me for about a week now and I need assistance. My work's scheduling program produces a horrible table to track schedules and I am trying to take the information it outputs and create a printable schedule from it. I have been able to do it for most of the...

Effectively, any of the office 365 equations *IFS do not seem to dynamically update when new information is presented in the range, they stick to the first answer given and then just repeat. The real formula is quite long and it works well enough (though I'm sure there are faster ways). I have...

Hello, A formula I am trying to use: =IF(A2<>0, MAXIFS('Current 6 months'!J:J, 'Current 6 months'!A:A, A2)+MAXIFS('Previous 6 months'!J:J, 'Previous 6 months'!A:A, A2), "") Is returning weird results. It has to look over two sheets and return the latest absence start date from column J -...

Good morning, Below is the formula that I am working with. My goal is to have the 2nd criteria be if the value in that cell is greater than zero. How do I enter that? What I have highlighted in red is my latest unsuccessful attempt. Thank you...

Hello all! I have scoured the forum, but I haven't seen anybody with a similar issue. I have a table similar to the one below. I am using the two formulas below to return the most recent cleaning done to this particular piece of equipment on a separate tab. The first one returns the date, and...

Hello all! New User here, so bear with me I'm working on a little pet project, attempting to parse out data from a large date range using smaller date ranges. The goal is to automatically get references given a date range that can be used for math in other cells. Most of this can be done with...

Hi I'm basically looking for a VLOOKUP where it would have multiple hits but only to return the MAX hit value. I thought MAXIFS was my saviour however my ranges aren't the same sizes. Any ideas on what else I could try please? Many thanks

Hi All, I have a real problem which I just cannot resolve, struggling to even know where to start to be honest! So.... I have a workbook called "Subcontractor Order Record". Within that work book are 2 worksheets, once called "Order Record", as follows: and one called "Payment Record", as...

hello all. i have sales data with the following: A B C D Month-year | Part number | SALE QTY 2020 | SALE QTY 2019 02/2020 XXXX 2 ..... ... ... XXXX...

Hi everyone, I just finished writing a decent TO-DO list that was to be used at the office while working on my home computer. Unfortunately my office doesn't have working MAXIFS functions with their version of Excel... I've looked up a few alternatives but I don't think an array will work...

Hi guys, i feel like this should be simple but i have no idea how to do it, would love some help. Consider the table below. I need a new column on the end with a formula that provides the maximum value from the position column that also has a 1 in the place field for all records with the same...

Good day experts, I have great need for a formula that outputs either TRUE/FALSE based on some criteria, the sample table is as follows: <tbody> (A1)EMP ID HRS WEEKDAY OUTPUT 0001 9 1 FALSE 0001 9 2 TRUE 0001 9 3 TRUE 0001 9 4 TRUE(D5) 0001 6 5 FALSE 0002 6 1 FALSE 0002 7 3 NOT...

I`m trying to work out a formula, on how to get the MAX amount, for any 30 day consumption period, for a certain item, when all the criteria are in one data table. I have created a formula in column D, that Sums up the amount used in the last 30 days. The Pivot table in columns A & B...

Hi, I have the following code which works on Office 365 using MAXIFS MAXIFS(Table1[Date],Table1[Name],D13,Table1[7 Dwarf],H13,Table1[Type],"<>"&"*Yes*")) Essentially it provides the maximum date that matched 3 criteria (name=D13, 7 dwarf = H13, type not contain Yes) Problem is I'm trying to...

Hi all, not a ton on this since i think Maxifs are for the newer version of excel? Anyway, here is the formula I'm trying to use: =MAXIFS(B:B,LEFT(F:F,3),K1) K1 contains the first 3 letters of a postal code, column F has full 6 digit postal codes, column B has numbers that i want to return...

Hi! I need some help. I want to find the second largest value in an MAXIFS function. My Maxifs function only returns the highest. I've tried to use the large function around the maxifs but it didnt work. Any suggestions? Thanks for helping!

Morning everyone, hoping you can help. We are trying to create a function to help us save money on materials. We want to know if we cut the box for product 987, which other products box would: 1. use the most of the remaining cardboard and 2. where more than one option will use the same...

I have an two-dimensional in cell array {0,2;3,0;0,5;6,0;0,0;0,8} and I would need to to get Max value of each column in a single cell. So, I would like to get {6,8} as a response from {=MAX({0,2;3,0;0,5;6,0;0,0;0,8})} instead of just 8. <tbody> 0 2 3 0 0 5 6 0 0 0 0 8 </tbody> In...

Hi, I am currently using excel 2010 and there is no "MAXIFS" function. Is there a workaround for this? I am trying to make something like this: =SUMIFS(TableY[Zone Yield],TableY[Date],">="&B4,TableY[Date],"<="&B5) Except with a MAXIFS instead of SUMIFS. Any help would be extremely...