Stack Overflow
Stack Overflow

Questions tagged [maxifs]

The MAXIFS function was introduced with Excel 2016. It allows the user to retrieve the largest numerical value dependent upon criteria in other columns or the column where the maximum is being retrieved.

See MAXIFS function for more information.

44 questions
4
votes
1 answer

MAXIFS with ARRAYFORMULA not working in Google Sheets

Please help wonderful people! I'm trying to use a MAXIFS formula within an ARRAYFORMULA in Google Sheets to obtain the latest date in column A from sheet 1, where the value in column A of sheet 2 matches in column E in sheet 1. Here's my…
Charlie Merritt
  • 43
  • 1
  • 3
3
votes
1 answer

Perform Excel MAXIFS in Pandas with multiple conditions

Issue I'm trying to create using Pandas a new column returning the next max of the 2 next days of each id/date. Below input data and the data I expect to get. I came up with a naive solution with iterrows (see bellow), but I would like to : find a…
Alexandre_K
  • 71
  • 4
2
votes
2 answers

Identify and remove remove duplicates from three columns and keep oldest - Excel

I want to identify duplicates that have the same "CustomerName" "ZipCode," and "DOB," and only keep the record with the oldest "Date." For instance, below, I want to remove the second John Smith record as it is the newer…
Matthew L
  • 21
  • 2
2
votes
1 answer

excel Max IF function

I was reading the following post which really helped: "I am trying to find the maximum value based on another column. This is what I have tried: =MAX(IF(Sheet3!$B$2:$B$5491=Sheet4!A3,Sheet3!$E$2:$E$5491)) How I am reading this code is that if the…
jacob moushon
  • 21
  • 2
1
vote
2 answers

Why is my XLOOKUP, with a nested MAXIFS, unable to give me an exact match?

First off, here is my formula: =XLOOKUP(MAXIFS(D:D,E:E,">0"),(B:B=F2)*(A:A="EFP")*D:D,C:C,,-1) CAMPAIGN RECORD PHONE# REP # PAYMENT DATE PAYMENT AMT LEAD PHONE…
cheese10234
  • 111
  • 8
1
vote
1 answer

MAXIFS + Array Issue

It's my first time posting in Stack Overflow so I do apologize if there are any format or etiquette issues. My array formula is not behaving as an actual array formula. It's just giving me results on the first cell, and then it does not autopopulate…
literarymanchester
  • 23
  • 3
1
vote
1 answer

Sum a column based on max date and unique range

Basically, trying to figure out how I can Sum the totals column based on the latest/max date, by town, ie filtered by unique and the latest date for each row. Date Town Totals September 5 Loerie 9 November 8 Loerie 4 May…
Morgol
  • 13
  • 2
1
vote
1 answer

Using YEAR function in MAXIFS criteria in excel

I have a following spreadsheet, which contains the timestamp, a numerical result, and the time (duration) took to calculate the result. From this I need to calculate maximum value of Duration in 2019 I tried something like this, but the function…
ks2bmallik
  • 184
  • 3
  • 18
1
vote
1 answer

Nested if and max if statement in R error: unused argument

Still quite new to R and I would like to identify the biggest value of a variable within a group when an other variable is postive/negative. Specifically, if l_diff<0, I would like to find the biggest value of t in each group when pos_n<0. If…
Anna
  • 177
  • 13
1
vote
1 answer

EXCEL Finding a cell text when calculating a Maximum value with INDEX and MAX

I have been trying to get this to work for days but I am not getting anywhere. I have a sheet with locations and temperature recordings during different days by different people. I would like to find the latest date a measure was taken by location…
EYM
  • 11
  • 1
1
vote
2 answers

get max value using checkbox selections

I am trying to implement a function in google sheets that will provide the max value from a set of values in column B based on the corresponding checkbox in column C. I was able to get the sum to work using: =sumif(C3:C7, TRUE, B3:B7) However, I…
Carter
  • 11
  • 2
1
vote
1 answer

Find a value of a cell next to the max value

I have a sheet with 3 columns: Employee, Role, Start Date Each employee has multiple records (his history in the company). I have a list of all the employees (distinct list) and I want to have a column of the current role for each employee - which…
Doron Goldberg
  • 643
  • 1
  • 9
  • 23
1
vote
3 answers

MS Excel 2010 MAXIFS equivalent in VBA Userform

I've created an Excel Userform to facilitate the data entry of new lines into a contract register. I have a field that auto-generates a new unique contract number by looking for the largest number in the list of contract numbers (Column A) and then…
Uvulagirl
  • 17
  • 1
  • 7
1
vote
1 answer

I need help to create a miniifs vba function?

I do some macro and i upgrade a macro of Diedrich to have a MaxIfs in excel 2010 which work with line an columns i put the code under. Public Function maxifs(MaxRange As Range, ParamArray Criteria() As Variant) As Variant Application.Volatile Dim n…
Nicpir
  • 13
  • 1
  • 3
1
vote
1 answer

How to use Excel 2016 maxifs function to find maximum value for specific month

Good morning, I'm using Excel 2016 to analyze stock data. I need to find the maximum value for a data range within a specific month. I know how to do this using several helper columns, but I'd like to take advantage of the "maxifs" function. I want…
Sescopeland
  • 315
  • 2
  • 16
1
2 3