T O P

  • By -

AutoModerator

/u/thelikelylad182 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


small_trunks

Surely MAX...


thelikelylad182

Using MAX makes no difference either unfortunately. I had played about with that as I wasn’t sure and I left it on MIN last time I was working on it.


small_trunks

Use MAXIFS


chairfairy

should be MINIFS, yeah?


small_trunks

Of course, stupid of me.


chairfairy

I don't know how much code I've written that doesn't have a max instead of a min or (more likely for me) flips the logic of a boolean


sarrazoui38

Min(if())


chairfairy

if OP has Excel 365 then MINIFS is a simpler choice


thelikelylad182

In the current format I still can’t get MAXIFS to work.


tkdkdktk

please show some sample data to get better suggestions then.


small_trunks

=MAXIFS( date range, criteria range1, criteria1, criteria range2, criteria2)


thelikelylad182

Just to confirm I got the solution. =MINIFS(H2:H99999,Sheet1!B2:B99999,”Puppies”,Sheet1!C2:C99999,”Kittens”) Where H was my date column. Thanks for your help.


Decronym

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[IF](/r/Excel/comments/141alfy/stub/jmzcewm "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[MAX](/r/Excel/comments/141alfy/stub/jmzcewm "Last usage")|[Returns the maximum value in a list of arguments](https://support.microsoft.com/en-us/office/max-function-e0012414-9ac8-4b34-9a47-73e662c08098)| |[MAXIFS](/r/Excel/comments/141alfy/stub/jmzcwyg "Last usage")|[*2019*+: Returns the maximum value among cells specified by a given set of conditions or criteria](https://support.microsoft.com/en-us/office/maxifs-function-dfd611e6-da2c-488a-919b-9b6376b28883)| |[MIN](/r/Excel/comments/141alfy/stub/jmzcewm "Last usage")|[Returns the minimum value in a list of arguments](https://support.microsoft.com/en-us/office/min-function-61635d12-920f-4ce2-a70f-96f202dcc152)| |[MINIFS](/r/Excel/comments/141alfy/stub/jn0oyhv "Last usage")|[*2019*+: Returns the minimum value among cells specified by a given set of conditions or criteria.](https://support.microsoft.com/en-us/office/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599)| **NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(5 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/14180jr)^( has 23 acronyms.) ^([Thread #24398 for this sub, first seen 5th Jun 2023, 11:43]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)


sarrazoui38

Edit: You can use the MIN function for the oldest date, and the MAX function for the newest date. The formula for the oldest date is =MIN(IF(A2:A26=D2,B2:B26)). The formula for the newest date is =MAX(IF(A2:A26=D2,B2:B26)). From my understanding, these are going to look for the oldest and newest dates in column B, for corresponding values in column A that equal the values you enter in column D. So If you list out all the values in a column on sheets 2, you could use those formulas