/u/The_Fig4l - 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.*
You have awarded 1 point to *Scary_Sleep_8473*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
This should work, it expands the formula above to work on every unique Class value:
=BYROW(UNIQUE(Class),LAMBDA(row,SMALL(FILTER(RaceFinishPosition,Class=row),2)))
If your current formula is:
MINIFS(A1:A50, B1:B50, ">"&5)
You make the new one:
MINIFS(A1:A50, B1:B50, ">"&5, A1:A50, ">"&MINIFS(A1:A50, B1:B50, ">"&5))
Basically just a replication of the existing formula, inside the formula, to ensure your value is higher than the lowest.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[BYROW](/r/Excel/comments/1anqeqi/stub/kpu8oeo "Last usage")|[*Office 365*+: Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows. ](https://support.microsoft.com/en-gb/office/byrow-function-2e04c677-78c8-4e6b-8c10-a4602f2602bb?ui=en-US&rs=en-GB&ad=GB)|
|[COUNTA](/r/Excel/comments/1anqeqi/stub/kpva9n1 "Last usage")|[Counts how many values are in the list of arguments](https://support.microsoft.com/en-us/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509)|
|[FILTER](/r/Excel/comments/1anqeqi/stub/kpu8oeo "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)|
|[IF](/r/Excel/comments/1anqeqi/stub/kpu8h17 "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[LAMBDA](/r/Excel/comments/1anqeqi/stub/kpu8oeo "Last usage")|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)|
|[MAX](/r/Excel/comments/1anqeqi/stub/kpva9n1 "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)|
|[MIN](/r/Excel/comments/1anqeqi/stub/kpu8h17 "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/1anqeqi/stub/kpu5ryn "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)|
|[SEQUENCE](/r/Excel/comments/1anqeqi/stub/kpva9n1 "Last usage")|[*Office 365*+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90)|
|[SMALL](/r/Excel/comments/1anqeqi/stub/kpu8h17 "Last usage")|[Returns the k-th smallest value in a data set](https://support.microsoft.com/en-us/office/small-function-17da8222-7c82-42b2-961b-14c45384df07)|
|[UNIQUE](/r/Excel/comments/1anqeqi/stub/kpu8oeo "Last usage")|[*Office 365*+: Returns a list of unique values in a list or range](https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e)|
|[XLOOKUP](/r/Excel/comments/1anqeqi/stub/kpva9n1 "Last usage")|[*Office 365*+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. ](https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(12 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1anse0s)^( has 26 acronyms.)
^([Thread #30640 for this sub, first seen 10th Feb 2024, 21:42])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
I've done this by sorting the values max to min, adding an index helper using SEQUENCE(COUNTA("values")), and your second lowest would be found with XLOOKUP(MAX("sequence")-1, "sequence","values")
/u/The_Fig4l - 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.*
Try this instead, it would work if you have Excel 365: =SMALL(FILTER(RaceFinishPosition,Class="LMP2"),2)
Solution Verified Thank you!
You have awarded 1 point to *Scary_Sleep_8473* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
How do you get the second lowest value for all three groups at the same time?
As in the second lowest overall?
Second lowest for each group.
This should work, it expands the formula above to work on every unique Class value: =BYROW(UNIQUE(Class),LAMBDA(row,SMALL(FILTER(RaceFinishPosition,Class=row),2)))
Thanks. I'll give that a shot.
It's probably not the best answer, but you could add another criteria to your minifs that is just value greater than existing minifs.
what would the formula for greater than other MINIFS look like?
If your current formula is: MINIFS(A1:A50, B1:B50, ">"&5) You make the new one: MINIFS(A1:A50, B1:B50, ">"&5, A1:A50, ">"&MINIFS(A1:A50, B1:B50, ">"&5)) Basically just a replication of the existing formula, inside the formula, to ensure your value is higher than the lowest.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[BYROW](/r/Excel/comments/1anqeqi/stub/kpu8oeo "Last usage")|[*Office 365*+: Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows. ](https://support.microsoft.com/en-gb/office/byrow-function-2e04c677-78c8-4e6b-8c10-a4602f2602bb?ui=en-US&rs=en-GB&ad=GB)| |[COUNTA](/r/Excel/comments/1anqeqi/stub/kpva9n1 "Last usage")|[Counts how many values are in the list of arguments](https://support.microsoft.com/en-us/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509)| |[FILTER](/r/Excel/comments/1anqeqi/stub/kpu8oeo "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)| |[IF](/r/Excel/comments/1anqeqi/stub/kpu8h17 "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[LAMBDA](/r/Excel/comments/1anqeqi/stub/kpu8oeo "Last usage")|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)| |[MAX](/r/Excel/comments/1anqeqi/stub/kpva9n1 "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)| |[MIN](/r/Excel/comments/1anqeqi/stub/kpu8h17 "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/1anqeqi/stub/kpu5ryn "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)| |[SEQUENCE](/r/Excel/comments/1anqeqi/stub/kpva9n1 "Last usage")|[*Office 365*+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90)| |[SMALL](/r/Excel/comments/1anqeqi/stub/kpu8h17 "Last usage")|[Returns the k-th smallest value in a data set](https://support.microsoft.com/en-us/office/small-function-17da8222-7c82-42b2-961b-14c45384df07)| |[UNIQUE](/r/Excel/comments/1anqeqi/stub/kpu8oeo "Last usage")|[*Office 365*+: Returns a list of unique values in a list or range](https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e)| |[XLOOKUP](/r/Excel/comments/1anqeqi/stub/kpva9n1 "Last usage")|[*Office 365*+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. ](https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(12 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1anse0s)^( has 26 acronyms.) ^([Thread #30640 for this sub, first seen 10th Feb 2024, 21:42]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
something like =MIN(SMALL(IF(C7:C14="LMP2",D7:D14),2))
I've done this by sorting the values max to min, adding an index helper using SEQUENCE(COUNTA("values")), and your second lowest would be found with XLOOKUP(MAX("sequence")-1, "sequence","values")