bottom 5 values

  1. H

    Need a formula to find bottom 5 values

    Hi, Is there a formula(s) which can help me find bottom 5 values from a set of values? Lets say I have a set of 20 values in % format. And there are 20 such rows. Now, I need to find the bottom 5 of each 20 values of each row. (Hope this is not confusing. If any problem, please let me know.)

Some videos you may like

This Week's Hot Topics