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
1
vote
1 answer

IF Duplicate value in Column B&C return the greater Price in G

SO, trying to brainstorm if this is possible. You guys are my go to. First I needed to call out the Duplicates. Which I can do and did with this formula. =IF((B16&C16)=(B15&C15),"X",IF((B16&C16)=(B17&C17),"X","")) But then I need to call out the…
Sam Russo
  • 145
  • 1
  • 3
  • 18
0
votes
0 answers

How Can I Increase The Speed Of My MAXIF Formula?

I would like to increase the speed of my MAXIF function. Not sure if there is a simpler way to write this, but I have the following formula: =MAX(IF('DH'!$D$1:$D$1048573=$A4,IF('DH'!$N$1:$N$1048573="Proactive",'DH'!$A$1:$A$1048573," "))) Currently…
Paul K
  • 1
0
votes
1 answer

Max value if not this in excel

With the following data set, I want to find the max and min value across rows, and then report the corresponding letter associated with the value. So if the max value is 0.19 and the associated letter is U, then I would like it to populate in a…
Rachel Gladstone
  • 37
  • 4
0
votes
2 answers

Google Sheets - Using MAXIFS within ArrayFormula

I'm reaching out because I'm facing an issue in Google Sheets for which I can't find a solution and I'm certain someone here might have an answer to save me. The situation is actually quite simple : In the D column of my sheet, I have a list of…
Arno B
  • 1
0
votes
1 answer

Google Sheets - get date of max value

I would like to populate a cell which gives me the date where sales was the highest for that period. eg. if I have 2 months, I would like to have a cell saying 14/01/2023 if that was the day with the highest sales. Q - sales values R - Year I can…
c492681
  • 1
0
votes
0 answers

latest timestamp with not null values using multiple conditions

I have been using Google Forms to get some data from users. This is the output. data table 1 I used a a combination of index match and Max ifs functions, but was unable to get the cost value of 4 and the comment "waste" for Berlin city and week W02.…
Shazzy
  • 1
  • 1
0
votes
1 answer

Why is Arrayformula returning only the first row

Update: sample sheet provided here: https://docs.google.com/spreadsheets/d/1BapXdaVOUL634SstNJXqYNocsD_EvvtlbJ77vlElmZs/edit?usp=drivesdk. Any help will be appreciated! Hi fellow nerds. I'm trying to make the current column (most recent interaction…
Meir
  • 15
  • 6
0
votes
1 answer

Excel get info about maximum value in a variable defined range

assume I have the following set of data : ID CAT VAL a a 4 b a 94 c b 5 d b 94 e c 2 f c 3 In Excel 2019 Pro get the maximum VAL of CAT=b using MAXIF(VAL,CAT=b) and I get 94. Now I want to get the ID of the…
philus
  • 51
  • 1
  • 3
0
votes
1 answer

How can I replicate this MAXIFS formula in DAX?

new to the board and have a frustrating issue blocking me from proceeding with a project. So I have a worksheet which documents times when warehouse pickers select items, and a formula that determines how long passed between picks, to monitor for…
AnalystMan
  • 13
  • 2
0
votes
1 answer

Finding highest selling item within a category

I am looking to find the highest selling drink within each category in cells C6:C16. I am able to find the highest value in each category with a MAXIFS function, but I want to further pull the corresponding beverage name (for example, Stella Artois…
difab
  • 59
  • 5
0
votes
0 answers

How to use operator in MAXIFS VBA EXCEL

Hope someone can help me. My main issue is to get the “>=” part to work in the Application.WorksheetFunction.MaxIfs function in VBA. I have a table with: One header row 125 rows of data Three columns: Time, Amount and Order ID I have three items…
Sjamsing
  • 57
  • 4
0
votes
2 answers

Looking for ArrayFormula specification for MAXIFS where criteria is based on unlimited values in another column

I have a gsheet with columns out to AC, most of which are filtered from another sheet which is, in turn, imported from an external source. The relevant columns are: C: where I want the found value to be (formula in C4, arrayformula populating the…
Sas
  • 51
  • 6
0
votes
1 answer

EDATE, MAXIF Leap Year for last year calc

For this example, The max date in column D is 2/28/2021. I'm trying to return the EOM value for the prior year which would be 2/29/2020 but instead this is returning 2/28/2020. What do I need to change for it to capture the leap year and always…
Eyan
  • 33
  • 2
  • 5
0
votes
2 answers

Formula to look up a range of values and return the max value?

I'm trying to create a formula that takes a list of values, correlates them to respective values in a table, and determines the maximum of the respective values. I've tried an array function (shown below) that is a combination of "max" and…
Hunter
  • 1
0
votes
1 answer

Excel: Highlight row that has max and min values in other columns

I have a simple Excel table that I want to highlight the row that has max in columns A,B, D and min in C. In this example it should highlight row 1 A B C D 1 36.4% 35.9% 2.25 272.8 2 19.4% 9.0% 6.5 122 3 …
munchine
  • 479
  • 1
  • 9
  • 23
1
2
3