DISTINCT finds the unique values in the specified data range. It returns this list of values in a single column. DISTINCT ignores case when comparing text strings. For example, \042Aaa\042 and \042aAa\042 and \042AAA\042 are all counted as the same value.

The DISTINCT macro function may take a long time to compute when data is large. A \042Computing...\042 progress bar will be displayed until the computation is complete. If you decide to cancel the computation, click on the \042X\042 in the progress bar and delete the function definition containing the DISTINCT macro function.