I have this formula-
=IF(C2="","",MINIFS($F$2:$F$10000,$O$2:$O$10000,O2))
This works fine and gives me the lowest value from range F2:F10
How could I change this formula so that it returns the second lowest value from the same range?
Thanks
I have this formula-
=IF(C2="","",MINIFS($F$2:$F$10000,$O$2:$O$10000,O2))
This works fine and gives me the lowest value from range F2:F10
How could I change this formula so that it returns the second lowest value from the same range?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks