Case-Sensitive Filtering

An Excel file that teaches how to perform Case-Sensitive Filtering operation.

Excel Format: Case-Sensitive Filtering

In the study, data filtering was carried out by preserving case sensitivity. Exact matching control is achieved by using the FILTER function and the EXACT function together. It is aimed to list the relevant rows if the values ​​in a certain column are exactly the same as the searched criteria. More precise filtering results were obtained by taking into account the differences in uppercase and lowercase letters. Thanks to dynamic array functions, automatic updating of the results is made possible. A general solution is presented to be compatible with different data sets and criterion values.

Hope it is useful.