+ Reply to Thread
Results 1 to 2 of 2

MINIFS to find the second lowest value

  1. #1
    Forum Contributor
    Join Date
    02-09-2007
    Location
    UK
    MS-Off Ver
    2019 & 365
    Posts
    304

    MINIFS to find the second lowest value

    Good morning all,

    What is the way to use MINIFS to find the second-lowest number in a column?

    =MINIFS('Test Logs'!$M:$M,'Test Logs'!$I:$I,B2,'Test Logs'!$J:$J,"Normal Test")

    This returns me 00:00:01 - Which is correct, but I need to find the next highest value over this which would be something like 00:04:25 in HH:MM:SS format.

    Thanks in advance.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,561

    Re: MINIFS to find the second lowest value

    Perhaps
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    IMO using entire columns as reference is bad practice

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Function to find fastest time for a period. Possible MINIFS solution?
    By ollyhughes1982 in forum Excel General
    Replies: 8
    Last Post: 08-03-2020, 05:28 PM
  2. Replies: 3
    Last Post: 06-13-2020, 10:28 PM
  3. [SOLVED] MAXIFS and MINIFS not available
    By TFiske in forum Excel General
    Replies: 7
    Last Post: 05-08-2019, 11:27 PM
  4. [SOLVED] how to find the lowest to highest value and display the name who is the lowest and the hig
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-23-2015, 09:20 PM
  5. Excel Help MINIFS
    By wolf767 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2015, 06:55 AM
  6. How to find duplicate entries, find which has the lowest value, and delete the rest?
    By John2810 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-05-2011, 06:39 AM
  7. Find lowest number in groups then lowest overall.
    By swieduwi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-24-2008, 01:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1