Dot function is used to retrieve the required information from a data type in a simplified manner. It basically used to find some data without infusing any complex conditional calculations and it helps the user to find the information spontaneously.
Basically a dot function contains two elements which includes a ” . ” notation.
- Cell generated with data type: This refers to the country/city/company name. probably you can give a reference.
Field name: This refers to the required data field. for example: Population, area etc.
Example using (.)Dot Function
While extracting the required data using field values, this is an alternative way of retrieving data. A simple self-constructed formula can be inserted in the formula tab to get the required data. This feature can be applied by following the steps as listed below:
To retrieve the data, the formula must be applied on the formula tab. If the user needs the population/area of the countries in the provided list.
- Step 1: Select the cells in the worksheet for which you want to return the area/population then the user must enter ” . ” along with the data field, a drop-down will be listed from which you can select the list of field you want to return. In this case, it is the population
The result will be projected as shown in the image.
Dot function is available only in Microsoft 365.
Note: In case there exists data in place of spilled range, a #SPILL error will appear. In simple terms, when the resultant area is not empty or consists of any value a #SPILL error is returned. This indicates that the range where the result needs to spill down is not completely blank.
To more on New Dynamic Array Formulas – click here
To know more about Rich Data Types in Excel please click here and don’t forget to subscribe to our youtube channel to get regular updates.