Function AI.FILL
The AI.FILL function fills an incomplete range by analyzing a provided example range to understand the pattern. Specify the example range with complete data, the partial range to be filled, and optionally, adjust the creativity level.
Examples
Filling in Missing Country code
=AI.FILL(A1:B3,A4:A7)
Syntax
AI.FILL(example,partial,temperature)
| Argument name | Description |
|---|---|
| example | Range containing complete data. |
| partial | Range containing incomplete data. |
temperature OPTIONAL |
Controls the creativity of the response, with 0 being the most predictable and 2 being the most random. The default value is 0. |