Microvellum Knowledge Network

Calculation speed of different functions

Would anyone know which of these would calculate the fastest?

      {=IF(Rib_X_List>0,Rib_X_List)}

      =LARGE(Rib_X_List,COUNTIF(Rib_X_List,">0"))

Or is there be a better way to find the smallest none zero value in the list Rib_X_List? Thx

    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        Google Review