Parametric Word Search and Filtering Applications

An Excel file that teaches how to perform Monthly Installment Calculation operation.

Excel Spreadsheet for Parametric Word Search and Filtering Applications

Search parameters are taken from separate cells. The FIND and MATCH functions are used together. The results list is dynamically generated. Partial matches are highlighted in color. A quick filter field is included.

Hope it is useful.