This section provides simple examples for how to use the
LISTIF functions. These functions include the following:
ANYIF- Identifies a single value from a group that meets a specific condition. See ANYIF Function.
LISTAIF- Lists all values within a group that meet a specified condition. See LISTIF Function.
The following data identifies sales figures by salespeople for a week:
In this example, you are interested in the high performers. A good day in sales is one in which an individual sells more than 80 units. First, you want to identify the day of week:Values greater than 5 in
DayOfWeekare weekend dates. You can use the following to identify if anyone reached this highwater marker during the workweek (non-weekend): Before adding the step to the recipe, you take note of the individuals who reached this mark in the
anyif_Salescolumn for special recognition.
Now, you want to find out sales for individuals during the week. You can use the following to filter the data to show only for weekdays:To clean up, you might select and replace the following values in the listif_Sales column with empty strings:
This page has no comments.