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.
Bookmarks