Per the title, I'm trying to convert this array formula to find the second smallest value:
=IF(L2=0,"NEVER",MIN(IF($B$4:$B$403=H2,$A$4:$A$403)))
I haven't had any success trying to fit in the SMALL and ,2. Any help would be greatly appreciated. Thanks!
=IF(L2=0,"NEVER",MIN(IF($B$4:$B$403=H2,$A$4:$A$403)))
I haven't had any success trying to fit in the SMALL and ,2. Any help would be greatly appreciated. Thanks!