Finding Lower and Upper Values

An Excel file that teaches how to perform Finding Lower and Upper Values operation.

Excel Spreadsheet for Finding Lower and Upper Values

Sequential values are obtained using the SMALL and LARGE functions. The range selection is dynamically defined. Blank cells are skipped by the filter. Error protection is provided by conditional statements. Results are reported in tabular form.

Hope it is useful.