TUG Tip - General Knowledge - Excel Filter Function

TUG Tip --General Knowledge

Excel Filter Function

Excel Tip: Excel has a feature called AutoFilter which allows you to filter a data range. The limitation to the AutoFilter is that it is anchored to the data range being filtered. What happens when you want to filter your data and put the results in another location on your worksheet or in the workbook.

Excel has a function for that, the FILTER Function. The Excel FILTER function is used to extract matching values from data based on one or more conditions. The output from FILTER is dynamic. This makes FILTER a flexible way to isolate and inspect data without altering the original dataset.

Below is the syntax for the FILTER Function:

=FILTER(array, include, [if_empty])

Look for Excel webinars from the TUG Construction Accounting (CA) Community this summer for demonstrations of this function and other Excel Tips and Tricks.