How to make a TOP 10 and a BOTTOM 10 in Excel using formulas

If all the data is located on column A, use this formula to rank the top values:

=LARGE(A:A,{1,2,3,4,5,6,7,8,9,10})

And this formula to rank the lowest values:

=SMALL(A:A,{1,2,3,4,5,6,7,8,9,10})

Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD

Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com