How to Find the Smallest or Largest Number in Microsoft Excel
Quick Links Summary Use the SMALL function to find the smallest number and the LARGE function to find the largest number. Use either Excel function in the form =SMALL(range,position) or =LARGE(range,position). For example, =SMALL(B2:E13,1) will find the first smallest number in the range of cells between B2 and E13. When you have a spreadsheet packed with data,finding the number you needcan be tedious. Yet, whether you’re looking for the lowest product sales amount or the highest test score, Excel’s SMALL and LARGE functions can help....