Excel Tips and Tricks for All Levels
Excel provides an easy way to list the k-th (first, second, third, etc.) largest number in a range. We’ll also take a look at the opposite situation where you want to find the 2nd smallest value in a range, for example.
Large & Small Formulas
So let’s go ahead and take a look at the formulas:
Loading ...#N/A Add Comments Auto_Open Basic Macro Cell Calculation Column Headers Concatenate Contest Count CountA CountBlank CountIf Custom Function Date Drop Down Menu Excel Formulas Excel Forum Excel Info Excel Macros Excel Version Extract Names Find Formatting HLookup Hyperlink ISBLANK ISERROR ISNA IsText Keyboard Shortcuts Large Left Length Loan Payment Calc Loops Macros or Formulas Macro Usage Match Mid Office 2010 Office Live Pivottable Protection Rank Record a Macro Right Select Whole Sheet Site Updates Small Status Bar Messages Substitute Sub vs Function Sum Across Sheets SumIf Text To Columns Today Trim Unique Values Userform Userform Attempt VLookup