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
0
votes
1 answer

How do I find the maximum and minimum against multiple string criteria (Google Sheets)?

I'm using imported data from a webpage into Google Sheets (using ImportJSON). From the table below, I want to find the maximum and minimum number in column "sell price min". In theory, data only counts if it's from the list of "Valid Cities" within…
Blueboy90780
  • 145
  • 1
  • 12
0
votes
2 answers

Excel - Use of MAXIFS (in excel 2010)

I want to solve a stock problem. I have stock from some articles in a specific store and I want to find out which store in the same country has the highest stock of this specific item. I use the table below for information input Column A: Article…
Wouter Groeneweg
  • 43
  • 1
  • 8
0
votes
0 answers

How to return Max number in Excel from 2 columns

I'm creating an excel spreadsheet to record results in a darts league. By entering the singles and pairs results from each match played including the number of tons scored, 180s hit, highest outshot and fastest leg, it automatically populates team…
Richard Smith
  • 11
  • 2
0
votes
1 answer

How to get the following result in excel without using MINIFS?

I have data in excel as following I want to get the following result Logic: For A - value in col 2, where the minimum of col 2 when col 1 is A and col 3 greater than zero. The same result can be easily obtained by using MINIFS(col 2, col 1,…
Sivakesav
  • 31
  • 8
0
votes
1 answer

How to use WorksheetFunction.max/maxifs to find maximum value in 'column' of multidimensional array

I have a 2-dimensional array in vba and I want to use worksheetfunction.max and worksheetfunction.maxifs to find the maximum value in a 'column' of the array. I'm aware that I can use a loop to do this, but the dataset is very large and I want to…
Peter
  • 26
  • 6
0
votes
1 answer

Vlookup value with criteria

I need to find vlookup matching value with predefined criteria from excel. Criteria: i) Need to consider picking value only if preferential value is "Y" ii) In case if name exist in more then two rows, need to consider row with maximum count…
Ganesh
  • 27
  • 5
0
votes
2 answers

Excel - Max Date based on Criteria in Table

In the table below, I'm trying to find the max date (most recent) based on the criteria "Major" for each facility. I tried using maxifs to no avail, and my table setup is different than any other post I've seen on here. Example - the date I'm…
sdb0020
  • 1
  • 1
0
votes
2 answers

Powerpivot: Retrieve max value for a group in a related table

I have 2 tables with a one-to-many relationship. -TableGroup: table with groupletter -TableAll: table with unique identifier, groupletter, a date Problem: I want to get the max value of the date from TableAll into a new column in TableGroup. See…
Dries_VB
  • 131
  • 6
0
votes
1 answer

duplicate formula with return info

I have a table with two columns A and B. On column A I have some ID s and on the B column and have dates. On A the Id s are not unique. I need you help to build a formula that will search on A for duplicates ID s and if there are, to show on C…
Iosif
  • 29
  • 1
0
votes
1 answer

Nesting Indirect function in Max array

I have a cell that is supposed to scan a range for a name, and then return the max (most recent) date from another range. Essentially I'm making a last date contacted cell for case managers. I had it all worked out but because I was using direct…
Dustin Burns
  • 307
  • 4
  • 13
0
votes
0 answers

Count Max Values of Top 1,2,3 on another workbook

I've trying to come up with a formula to automatically populate top 1,2,3 text occurrences from another Workbook, however I have multiple criterias that seem to be making it more difficult for me. So in Workbook 1, I have: Column A Dates ranging…
Chimi
  • 1
  • 2
-1
votes
2 answers

Get the shortest distance between two coordinates and return the adjacent cell

My spreadsheet contains data from hospital patients, based on different criteria, and one of them are household's coordinates. The question is which household is the nearest neighbour to the household that contains the most people, based…
andrea65
  • 67
  • 8
-1
votes
2 answers

Find value with the biggest age difference

I have a spreadsheet containing data from hospital patients. I'm running Excel 2021. I need to create a function (or a macro) that tells me how many people live in the household that has the biggest age difference between the oldest and the youngest…
andrea65
  • 67
  • 8
-1
votes
2 answers

Compare two Cells and Return Highest Value from third cells

Need help please. I am working on report which shows different names in coloumn A. I want to compare the two cells within the same coloumn and then display the highest value from COL B into COL C: COL A COL B COL C (OUTPUT…
Nomi
  • 17
  • 1
  • 6
1 2
3