Function AI.FILL
The AI.FILL function automatically fills missing or incomplete data in the specified fill_range by analyzing patterns, trends, or relationships in the provided example_range. It is ideal for automating data completion tasks for numerical, textual, or categorical datasets.
Examples
Filling in Missing Country code
=AI.FILL(A1:B3,A4:A7)
Syntax
AI.FILL(example_range, fill_range)
| Argument name | Description |
|---|---|
| example_range (required) | The range containing complete data that serves as the basis for the AI to detect patterns and relationships. |
| fill_range (required) | The range with incomplete data that will be filled based on the detected patterns from the example_range. |